Access Lock File Problem

  • Thread starter Thread starter KC
  • Start date Start date
K

KC

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???
 
Could be a network problem or a NIC going bad on one of the PCs. OR, you
may have one or more users who power down their PC with the database open.

I believe that Tony Toews has some tips on his site.

hth
 
KC said:
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?
Click to expand...

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
 
Back
Top