N/APosted on - 08/05/2011
I have an application issue here in Microsoft Access. I met an error while working. The error message went "Could not update; currently locked by user ‘admin’ on machine ‘PC04’." I pasted below the error message full text for your full view of the application issue.
ERROR [GY000] [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user ‘admin’ on machine ‘PC04’.
This error message that was displayed on my screen let me think for a long time on how can I solve the error. I already checked all the aspects the error message states, but I still get same error message.
Please share some ideas on how to solve this application issue. Thanks a lot guys for reading my post.
Could not update currently locked by user
Access Database currently locked by user.
This error occurs when the current database you are working on is opened maybe remotely or locally by some other users or in different instances. Microsoft Access database is not allowed to modify when opened in multiple instances. But you can set your database to enable multiple access or connection.
In some other way of programming using the Microsoft Access as their back-end, there are some instances that inside the program code, the database has been already opened and the programmer forgot to disconnect the open connection from the database. This will cause to pop up an error message like what you have encountered especially when your database is not multiple connections enabled.
When editing the database, like for example modifying the field data types which the schema is open, the Microsoft Access database is not allowed to be used for adding and modifying records at that moment. So you must close or finish your transaction first and close the database for you to move on the next step.
When a Microsoft Access Database was locked, you will see a locking file on the same folder where the access database was saved. The locking file is hidden and it is the same with the file name of the database but in different extension name. This will indicate that the file or the database file has been used by other person or user.
You must set your file explorer properties show hidden and system files before you can see the locking file. Please refer to your explorer help file on how to do it.