database is locked

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm getting following error when trying to open Access database:

The Microsoft Jet database engine cannot open the file
'C:\monitor\shipLogXp.mdb'. It is already opened exclusively by another user,
or you need permission to view its data.

I check the settings - it's set for shared and multiple access.

I made sure that I'm the only user who has access to this file. Set Full
control permission to the folder.

Any suggestions will be appreciated.
Thanks.
 
Hi, Alan.
I made sure that I'm the only user who has access to this file. Set Full
control permission to the folder.
Click to expand...

After you have closed the database application, is there an *.LDB file left
behind in the same directory as your database? This *.LDB file will have
the same base file name as your database file. For example, if your
database file were MyDB.MDB, then the locking database file name would be
MyDB.LDB.

If so, then delete the *.LDB file and attempt to open your database again.
If you can't delete it, then it may have a network lock on the file and the
Windows system administrator will need to remove the lock or reboot the
server for you.

If not, is this database secured using user-level security?

If so, then ensure that your user account has Open/Run database permissions.
If that's not the problem, then is the workgroup information file in the
same directory with the same base file name as your database file?

If so, then rename the database file or workgroup information file or move
one of these files to a different directory.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top