Error 200 - Record access is denied oddity

[BrentHedden]

One user has the default 'Data Entry Only' privilege set which works fine. On one particular table she needs to delete records.

No problem - I set up a script that first checks it's her, then deletes the record. It's running the 'Run script with full access privileges' checked.

The funny thing is, most of the records she can delete. Some return an error of 200 (Record Access is Denied) after attempting to delete the record. These are running the same script as described above, in the same table. A dialog box at the end of the script reveals that she is running the script as a privilege set of [Full Access], as it should.

Am I missing some kind of important information about why it would be returning this error some times but not others?

[Steven H. Blackwell]

Might there be related records involved with a cascading delete?

Steven

[BrentHedden]

Sure enough, it does. I didn't consider that being a hinder to deleting the parent record.

Thanks!

[Steven H. Blackwell]

Be sire that you have privileges to delete the downline records in the cascade and then it should work.

Steven