Access 2000 LockFile Problems

[Rus Moore]

Where can I find info about how to avoid and resolve
lockfile problems? I use a moderately complex Access 2000
Database system on a Windows XP computer. Very frequently
the lockfile (.ldb file) fails to close upon exit, and the
program refuses to re-open until I try this and that and
finally get it repaired or replaced from a backup. This
is a very serious problem, and I have been unable to find
good information about what causes it, how to avoid it,
and how to fix it when it happens.
Rus

 

[Biggles]

This may scare a lot of people, but I would like to know
the problem with it. I go into Windows Explorer and
delete the ldb file. I have been able to delete other
people's as well. What damage am I doing to my database?

 

[Tony Toews]

Where can I find info about how to avoid and resolve
lockfile problems? I use a moderately complex Access 2000
Database system on a Windows XP computer. Very frequently
the lockfile (.ldb file) fails to close upon exit, and the
program refuses to re-open until I try this and that and
finally get it repaired or replaced from a backup. This
is a very serious problem, and I have been unable to find
good information about what causes it, how to avoid it,
and how to fix it when it happens.

This is actually a corruption problem. The lockfile being present is
left behind whenever Access crashes.

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