MS-Access - Record Locked

Help
1

Hello,

I’m using a Ms-Access back-end database simultaneous with 2 scripts. 1 script (providing the data to a queue) run on 1 bot and the second script (processing the data read from the queue) run on 3 robots. The 4 robots run all the day long and also this database is shared with the business users.
I get often a message “record is locked” when updating a record meaning that the users need to check what was done or not.
I’m struggling to find a solution to avoid this situation.
I open the connection to the database at the start of the process and close it at the end of the process for both script.
Any suggestions/advies for best practices in this situation ?

PS : I think to migrate this back-end Ms-access database to a Ms-sql database, hoping it will solve the issue.

2

Hi Bruno,

Did you found a solution for record locks?

3

4 years later :smiley:

But there is no real solution other than not using MS Access.
An MS Access DB is not designed / optimized for multiple users using the same data file simultaneously, as it indeed results in locked records.

If there is no alternative to use as a DB, and you still want to solve this, you might want to configure the robots with enough retries on the query activities in the hope to avoid timing issues on the same record. But it’ll always be sub-optimal.