File Already In Use Message

[Nyla K]

Hello,

I have two databases that are stored in the network. One of the database is
the front-end, the other is the back-end. When trying to enter a record
using the front-end database, we are getting an error that says "Could not
use 'G:\CPTBE.mdb'; file already in use". The file in question is the
backend database.

Why are we getting this error and how can I unlock the database so that we
can start entering records? I have the backend hidden so that other users
can't view, delete, or modify it.

Thanks,
Nyla

 

[Douglas J. Steele]

Sounds as though either the front-ends are being open in Exclusive mode, or
else your users don't have the appropriate permissions on the folder where
the MDB files exist. All users require Read, Write, eXecute and Delete on
the folder: that's because the first user in needs to be able to create the
locking file (.LDB) in the same folder, subsequent users need to be able to
update that locking file, and the last user out needs to be able to delete
the locking file.

BTW, it's not recommended sharing the front-end. To get the true benefits of
splitting, each user should have his/her own copy of the front-end, ideally
on their hard drive. Sharing a front-end dramatically increases the risk of
database corruption.

 

[Nyla K]

Thank you, Douglas. I'll find out what kind of permissions each user is
given to access the mdb files.

Also, each user have his/her own copy of the frontend database in their
local drive. However, we have some end-users who chooses to create a
shortcut on their desktop by pointing to the main file. I wish there was a
way I can prevent these users from creating these shortcuts.

Thanks again,
Nyla