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.