FAQ's on corruptions and locking

[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"?

 

[peter]

Microsoft Access Links, Hints, Tips & Accounting Systems
at http://www.granite.ab.ca/accsmstr.htm

 

[Van T. Dinh]

Try Tony Toews' Web page:

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Dirk Goldgar]

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"?

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.

 

[Tony Toews]

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.

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

 

[Dirk Goldgar]

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

I defer to your opinion, Tony.