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 / Security / March 2007

Tip: Looking for answers? Try searching our database.

record locking

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Leslie - 28 Mar 2007 19:30 GMT
I have a front-end/back-end database that I would like to put the front-end
on about 15 users machines.  Currently the front-end is loaded on 4 machines
with the back-end on the server.  The first three people can open and the db
and add records with no problems.  When I added the 4th person, she keeps
getting a "file is in use" message.  It's not saying what file.  I have went
into both the front-end and back-end to unselect "edited record locking" and
made sure both db are set to "shared".  I don't see any record locking
options at the table level.  Also, when any of the user open front-end and go
to a specific form it throws a copy of the db out there .ldb.  I have made
sure all the users have gotten a new copy of the front-end on their desktop.  
I have made sure their all running the same runtime version with current
updates.  I'm not understanding why it works for 3 users and 4th user is
having problems.  Any help would be appreciated.
Signature

Leslie

Keith Wilby - 29 Mar 2007 08:05 GMT
> Also, when any of the user open front-end and go
> to a specific form it throws a copy of the db out there .ldb.

I don't know about your other problem but this behaviour is normal so you
can eliminate it from your enquiries.  The ldb file is for record locking
purposes.

Keith.
Keith Wilby - 29 Mar 2007 08:20 GMT
This question has been multi-posted and is being answered elsewhere.
 
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.