Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / February 2007

Tip: Looking for answers? Try searching our database.

Couldn't use <filename> File already in use

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DeanL - 01 Feb 2007 18:33 GMT
Hi Guys,

I've been trawling through this group for an answer to this but can't
find one that works.  I have an Access 97 db sitting on a Novell
server that is accessed via a front end with linked tables.  There are
several users that need access to this db but some get the  "Couldn't
us <filename> File already in use" error.  Every user has the same
level of access rights to the server and their accounts are all
identical but some still can't access it while others have no
problem.  I've checked Microsoft's knowledge base but their answer is
based around access rights which I've already checked.

Does anyone know why this happens and how it might be solved.

Many thanks, Dean...
Tim Marshall - 01 Feb 2007 19:22 GMT
> Does anyone know why this happens and how it might be solved.

One thing to check - when you get a user reporting this issue, check to
see if there is an equivalent locking file, ie, ldb extension, on the
server share.  IOW, if your mdb is MyProject.mdb, when someone has it
open, there should be a MyProject.ldb.

Check for this.  The error you are reporting sounds as if when a user
opens the mdb, the locking file is not being created.
Signature

Tim    http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto  "TIM-MAY!!" - Me

DeanL - 01 Feb 2007 20:54 GMT
On Feb 1, 11:22 am, Tim Marshall
<TIM...@PurplePandaChasers.Moertherium> wrote:
> > Does anyone know why this happens and how it might be solved.
>
[quoted text clipped - 10 lines]
> /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
> /^^ "Be Careful, Big Bird!" - Ditto  "TIM-MAY!!" - Me

Hi Tim,

Thanks for that but the locking file is present for the people who get
into the db without a problem, for the other people the locking file
isn't being created because the db doesn't even get as far as opening.

Dean.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.