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 / Forms / May 2008

Tip: Looking for answers? Try searching our database.

Couldn't update; currently locked by user Error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
scott04 - 09 May 2008 16:28 GMT
Hi everyone,
I have a database that i designed for a department that has approx 8 users.  
It is setup on a shared drive with FE and BE.  All users have read and write
access to folders.  Each user has a seperate copy on their desktop that they
access.  My users from time to time receive the message, "Couldn't update;
currently locked by user" when they try to save a record.  Here is the
setting i am using:
Access 2003
Default open mode Shared
Default record locking Edited Record
OLE/DDE timeout 30
Refresh interval 60
number of update retries 2
ODBC refresh interval 1500
Update retry interval 250

I have not found anywhere with a clear cut solution to this problem other
than having all users logout.  I have done this and when the problem does
occur this does not resolve the issue.  I have heard suggestions of changing
the Refresh Interval from 60 to 2 sec?  Will that help?  Also i have heard to
have individual copies repaired and compacted?  Will that work?  Any feedback
is appreciated.
Maurice - 09 May 2008 18:06 GMT
Having users uncheck the option to repair and compact on close migth be an
issue in this case. Let them uncheck this feature and see if the problem
decreases...
Signature

Maurice Ausum

> Hi everyone,
> I have a database that i designed for a department that has approx 8 users.  
[quoted text clipped - 18 lines]
> have individual copies repaired and compacted?  Will that work?  Any feedback
> is appreciated.
scott04 - 09 May 2008 18:31 GMT
Maurice,
Thank you for your reply but this box is not checked off.  When i was
referring to compacting i was asking if maybe my users should try doing that
one time.  The setting you are referring to already is setup that way.

> Having users uncheck the option to repair and compact on close migth be an
> issue in this case. Let them uncheck this feature and see if the problem
[quoted text clipped - 22 lines]
> > have individual copies repaired and compacted?  Will that work?  Any feedback
> > is appreciated.
scott04 - 12 May 2008 19:30 GMT
Does anyone else have anything else they can think of for me to try.  The
database is fine today but i would like to change the setting if possible to
avoid any future instances of this issue.

> Maurice,
> Thank you for your reply but this box is not checked off.  When i was
[quoted text clipped - 27 lines]
> > > have individual copies repaired and compacted?  Will that work?  Any feedback
> > > is appreciated.
 
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.