Error 200 when deleting a record

1

I'm encountering a strange issue and could use some advice. I have a script that commits a record and then deletes it without dialogue. However, when I run the script in the debugger, I consistently get Error 200 (Record access is denied).

Here’s what I’ve done so far:

  • I’ve verified that the script runs with Full Access privileges.
  • The user executing the script also has a privilege set with delete rights for the table.
  • I checked the relationships, and I don’t think that’s the issue. The record isn’t locked or related in a way that should prevent deletion.

This is my first time seeing Error 200, and a Google search mentioned relationships or privilege issues, but I’ve ruled those out (or so I think).

Does anyone have tips for debugging this or suggestions on what else to check? Thanks in advance!

2

I suggest you show your script, that would help us figure what is going on.

1 Like
3

The issue here is likely that once the record is created, you remain on that UNCOMMITTED record which is locked open.

Add a commit after creation and it should work

1 Like
4

Kirks Idea seemed to do the trick!