error message reading could not lock

R

Rochell

when ever someone logs into my database, and another person tries to access the same database in the same location, it displays "COULD NOT LOCK FILE"

I have split the database, and that doesn't seem to work. I have had to resort to setting up different folders for each individual with a copy of the database inside their prospective folders. each of these databases are linked to the original database, but I would like to resolve the problem of users being unable to access the same database at the same time.
 
C

Cheryl Fischer

Hello Rochell

When the first user is able to open a database and subsequent users cannot
get in, this is often due to improper network permissions on the folder in
which the database is located. Each user must have Full permissions (Read,
Write, Create, Delete, Execute) on the folder in which the database is
located. This is required so that Access can properly manage the LDB file
that is created when the first user opens the database.

hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Rochell said:
when ever someone logs into my database, and another person tries to
access the same database in the same location, it displays "COULD NOT LOCK
FILE".
I have split the database, and that doesn't seem to work. I have had to
resort to setting up different folders for each individual with a copy of
the database inside their prospective folders. each of these databases are
linked to the original database, but I would like to resolve the problem of
users being unable to access the same database at the same time.
 

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

Top