The first thing to try is making sure that the database is closed and that no
one else is using it. Next go to the folder holding the database file and
look for a .ldb or .laccdb file with the same name as the database file. This
is a locking file that might be the problem if you are very lucky.
If not, the database may be corrupted. Make a copy of it now and put it in a
safe place. Next open up just Access and do a Compact and Repair of that
database. Better yet download the Jetcomp.exe utility from Microsoft as it
does a better job of fixing database errors.
Tony Toews has an excellent web page on database corruption.
Http://www.granite.ab.ca/access/corruptmdbs.htm
Allen Brown also has excellent info on corruption.
Http://allenbrowne.com/ser-47.html
I have a white paper in a Word document named Fix Corrupt Access Database.
Click on "Whittle, Jerry" on this page:
http://www.rogersaccesslibrary.com/forum/default.asp?C=1
