Accesslock.ldb file

[Guest]

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

 

[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.

 

[John W. Vinson/MVP]

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?

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

 

[Joseph Meehan]

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

The LDB is just a file to keep track of who is accessing it. It is not
your problem. I would guess the link to the Excel file is your problem.