How do I resolve a security error message and open mdb

G

Guest

The database was secured using the Security Wizard but whenever we try to
open it the following message displays: "The Microsoft Jet database engine
cannot open the file: (directory and name of file). It is already opened
exclusively by another user or you do not have permission to view its data."
But the database isn't opened by another user and permissions were
established for the user trying to open it. No logon box appears and we cant
get passed this error message. We are using MS Access 2000 and appreciate
any help you can provide.
 
W

Wayne Morgan

The locking file is supposed to be deleted when the last user closes Access.
Sometimes it isn't. Check the folder where the front-end and back-end files
are located (the problem is probably in the back-end). With no one using the
database, check for an *.ldb file with the same name as the *.mdb file. If
the *.ldb file exists and no one is using the database, delete the *.ldb
file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error message 3051 encountered when trying to edit Access database 3
cannot connect to back-end .mdb 4
TransferText Error 3
database opened exclusively by another user 1
Cannot open .mdb file by double click when another user has opened 5
Wise to set up user level security for a multi FE MDB ?? 9
mdb looks and acts like mde 3
Recovering the mdb 3

Top