If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
File Already In Use Message
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 |
#2
|
|||
|
|||
File Already In Use Message
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 |
#3
|
|||
|
|||
File Already In Use Message
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 "Douglas J. Steele" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Importing Contacts from Work to Home Computer in Outlook | Debbie | Contacts | 3 | March 16th, 2005 10:14 PM |
Jet35.sp3 | doglover | Database Design | 3 | August 26th, 2004 04:41 PM |
Application must be installed to run Error | Keith | Setup, Installing & Configuration | 1 | June 29th, 2004 03:02 AM |
Continual Error 1321 Trying to Install Office 2003 | Chad Harris | General Discussions | 9 | June 11th, 2004 08:19 AM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |