database needs to be repaired

[benj]

whats wrong with my database. i've been using this database for years, now it
keeps crashing. a pop-up window will appear saying thet "The database
"C\Documents.....\myDATAbase.MDB" needs to be repaired or isn't a databse
file.

please help! thanks!

 

[Van T. Dinh]

1. Have you tried Compact and repair your database?

2. Have you tried JetComp.exe?

3. Have you tried creating a new blank database and importing all objects
from the existing database to the new database?

 

[Allen Browne]

Presumably you tried the compact/repair (Tools | Database Utilities.)

If that can't rescue it, you might try Microsoft's JetComp utilitity:
http://support.microsoft.com/kb/273956/en-us

Otherwise you could be looking at a professional restore service such as:
http://www.everythingaccess.com/accessdatabaserepair.htm
(Or better still, restoring a backup if you have a recent one.)

For suggestions on how to avoid the continued corruption, see:
Preventing Corruption
at:
http://allenbrowne.com/ser-25.html
It's a lengthy list of things to work through, but they are all important
issues.

 

[Duane Hookom]

Try read up on corruption with links found at Tony Toews page
http://www.granite.ab.ca/access/corruptmdbs.htm.

You may need to restore from a backup.

 

[John Vinson]

whats wrong with my database. i've been using this database for years, now it
keeps crashing. a pop-up window will appear saying thet "The database
"C\Documents.....\myDATAbase.MDB" needs to be repaired or isn't a databse
file.

please help! thanks!

It means your database has become corrupted. I hope you have a current
backup; you may well need it.

See

http://www.granite.ab.ca/access/corruptmdbs.htm

for causes, possible cures, and preventatives for such corruption.

John W. Vinson[MVP]