Unfortunately, it appears that your database is corrupt. First, always work
on a copy of the database. Working on the original may make it impossible
for a repair service to fix it.
Download a copy of JetComp.exe:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956
Also have a look at the Microsoft KB article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137
Then have a look at Tony Toews' Access Corruption FAQ at:
http://www.granite.ab.ca/access/corruptmdbs.htm
for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.
Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:
http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
dml said:
When I try to open my database I get a message saying THE DATABASE NEEDS
TO BE REPAIRED OR ISN'T A DATBASE FILE. YOU OR ANOTHER USER MAY HAVE
UNEXPECTEDLY QUIT MICROSOFT ACCESS WHILE A MICROSOFT ACCESS DATABASE WAS
OPEN. DO YOU WANT MICROSOFT ACCESS TO ATTEMPT TO REPAIR THE DATABASE. When
I click OK. It says THE DATABASE CAN'T BE REPAIRED OR ISN'T A DATABASE
FILE. The .lbd file still shows although no one is in the database. I have
been unable to re-open the database. This has happened 1 time before and I
am unsure why. Only one person uses this database at a time. The 2 users
never use it at the same time. On occasion, a user will log on by mistake
while I'm in there and I immediately tell them to log out until I have
finished and closed the database. Is there any way to restore this
file????????
