Access.LockFile.9 Error

[Khurram]

Several times a day, Access gets lock-up and I have to get
all users logout of database, then only delete
access.lockfile.9, then reopen access, it comes up with
message like "user closed database while access was
already open" and it repairs the database so people can
get back in. This is happening more and more frequently
now. Can somebody help resolve the lockfile issue? Does
anybody know why this happens???

 

[Tony Toews]

Several times a day, Access gets lock-up and I have to get
all users logout of database, then only delete
access.lockfile.9, then reopen access, it comes up with
message like "user closed database while access was
already open" and it repairs the database so people can
get back in. This is happening more and more frequently
now. Can somebody help resolve the lockfile issue? Does
anybody know why this happens???

It's not a lock file issue as such. But it sounds more like
corruption.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

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