March 3rd, 2003, 09:06 AM
I had never before programmed Access.
I am using Access forms.But when I try to connect to the database it says that Database was exclusively locked by unknown user.Please help me to overcome.I am using Access 2000.
March 3rd, 2003, 07:02 PM
Make sure the database is not being used by anyone else if on a network.
3 things you can try
1) Make sure the database is closed. Try to make a copy of the database. If you can't look in the directory containing the database for a file with the extension .ldb, if its there delete it. This should solve the problem.
2) In Access close any database thats open. From the file menu select Open. Locate the offending database. Open it with the Open button. This may make no difference but it might work.
3) Create a new blank database and Import all data and objects from the old database.
If all fail try looking on the www.microsoft.com knowledge base for an answer as well.
Best of luck ...
March 14th, 2003, 08:56 PM
A Nother Way
On the Tools menu, click Options.
Click the Advanced tab.
Specify whether a Microsoft Access database opens in shared or exclusive mode by default
You can select shared or exclusive to be the default way of opening the database.