Accesslock.ldb file

J

Jeff

I am getting an accesslock.ldb file created whenever someone is in the
database. It is preventing others from useing the database. I have split
the database, I have the option to share marked and no locks marked in
options? Could it be becuase the tables are linked tables to an excell file
and not created access tables?

Jeff
 
D

Douglas J. Steele

The only way to avoid a locking file is to open the database as exclusive
and read-only. However, it sounds as though your users are all attempting to
use the same mdb file, which is never recommended. Each user should have
his/her own copy of the front-end, preferably on his/her hard drive.
 
J

John W. Vinson/MVP

Jeff said:
I am getting an accesslock.ldb file created whenever someone is in the
database. It is preventing others from useing the database. I have
split
the database, I have the option to share marked and no locks marked in
options? Could it be becuase the tables are linked tables to an excell
file
and not created access tables?
Click to expand...

Yes. Excel spreadsheets are not database tables, and - as far as I know -
are not shareable, certainly not sharable for update.
 
Top