I have a macro performing a process where it opens a table selects all records then deletes all records. It works fine when I run the process locally but I get the 'Could not Update; Currently Locked' error when I run it on the network.
I have database set to exclusive and there are no other users attempting to access the databse at all. I anm testing as the administrator so I have full rights to all objects etc.
I have been searching past threads but haven't come up with a solution.
What can I do to prevent this locking error?
I have database set to exclusive and there are no other users attempting to access the databse at all. I anm testing as the administrator so I have full rights to all objects etc.
I have been searching past threads but haven't come up with a solution.
What can I do to prevent this locking error?