Error message: Cannot use file: file already in use...?

[Catchin'' On]

We just re-designed our office's network and our users cannot access the
database when another user have the file open. (Access - 2003).

I have the database split into FE and BE. The BE is on a shared drive on a
server, and the FE is on each user's computer.

It was all set-up and working perfect before we changed the set-up of our
network, but the way the database files are set up and accessed has not
changed.

Strangely, I have full administrative rights, and everyone else has
different permissions. If another user is accessing the db i can still open
it, but nobode else can open it if it is already opened.

I have run in circles trying to find out what is going on but i can't find it.

Can somebody please help me?

Thanks,
-H-

 

[John W. Vinson]

Strangely, I have full administrative rights, and everyone else has
different permissions. If another user is accessing the db i can still open
it, but nobode else can open it if it is already opened.

When an Access database is opened, the program creates a .ldb file to handle
file locking issues; it's created in the same folder as the .mdb file (if it's
not there already). The .ldb file is deleted when the last user exits. Both
the front and backends will have their own .ldb file.

Therefore, to use Access, any user must have FULL read. write, create and
delete privileges on the folder containing the .mdb file. (Well, delete isn't
actually required but if they don't have it the .ldb file will stick around
forever).

Do they?

 

[Catchin'' On]

John,

You Nailed it... thanks so much for the help... like always!

-H-