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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Nyla K" wrote in message
news
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