« Does anyone know a great tutorial for accessing my PC via FTP?
In Microsoft Access 2003, how do you display 4 digits of a year using Date/Time format in the field? »

How to unlock a access 2003 database?

Trying to "compact and repair" a Access 2003 database, but it says is in use by another user. I know that nobody is using the database, but still doesn’t want to repair, delete the database/lock file. Any way around ?

You need to go into administratror tools within the operating system. Select Computer Management, Shared Folders, Open Files and see if the Access Database in question is open. This has to be done on the computer that has the database file. If it shows up on the list of open files, select all instances and select close / disconnect open files. This should allow you to compact and repair the database if needed or simply remove it.

This entry was posted on Wednesday, November 25th, 2009 at 3:16 am and is filed under access 2003. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “How to unlock a access 2003 database?”

  1. rexecampbell Says:
    November 25th, 2009 at 8:43 am

    You need to go into administratror tools within the operating system. Select Computer Management, Shared Folders, Open Files and see if the Access Database in question is open. This has to be done on the computer that has the database file. If it shows up on the list of open files, select all instances and select close / disconnect open files. This should allow you to compact and repair the database if needed or simply remove it.
    References :

Leave a Reply