FAQ's on corruptions and locking

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I am having record locking problems with a split database
with multi users. A record within the data file will get
locked and everyone has to get out and I have to "Repair"
to get the record unlocked. What is going on?

Does anyone know the website URL for "FAQ's on
corruptions and locking"?
 
Mike said:
I am having record locking problems with a split database
with multi users. A record within the data file will get
locked and everyone has to get out and I have to "Repair"
to get the record unlocked. What is going on?

Does anyone know the website URL for "FAQ's on
corruptions and locking"?
Click to expand...

Others have pointed you to Tony Toews' page on MDB corruption, which is
a good resource. It occurs to me, though, that your problem may not be
corruption, but rather one of network permissions. IIRC, every user of
your database must have read, create, update, and delete permissions on
the folder containing the database, in order to allow Access to manage
the lock file properly. Possibly one or more of the users doesn't have
the full set of permissions.
 
Dirk Goldgar said:
Others have pointed you to Tony Toews' page on MDB corruption, which is
a good resource. It occurs to me, though, that your problem may not be
corruption, but rather one of network permissions. IIRC, every user of
your database must have read, create, update, and delete permissions on
the folder containing the database, in order to allow Access to manage
the lock file properly. Possibly one or more of the users doesn't have
the full set of permissions.
Click to expand...

In this case though you do get a permissions message so I'd suspect
some kind of corruption.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top