Access 2000 LockFile Problems

  • Thread starter Thread starter Rus Moore
  • Start date Start date
R

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
 
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?
 
Rus Moore said:
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.
Click to expand...

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