A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

File Already In Use Message



 
 
Thread Tools Display Modes
  #1  
Old November 21st, 2005, 10:55 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old November 22nd, 2005, 01:28 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old November 22nd, 2005, 01:45 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 11:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.