Access Lock File Problem

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

 

[Larry Daugherty]

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

 

[Guest]

Larry,

Where might I find Tony Toews' website?

Thanks,

 

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

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

 

[Tony Toews]

Where might I find Tony Toews' website?

See my sig. Or do a search on my name at google.com.

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