Repairing Database

[Mark]

A database we are using in access 97 returns a message
that it needs to be repaired upon opening. When we select
the repair option, it says that it is invalid and cannot
be repaired.

We have a 2-month old copy of the database that functions,
but the data tables are not up to date. This has happened
a few times before, but we were able to repair the
database temporarily (it would only work once and then ask
to be repaired each time upon opening) and extract the
data tables and paste them into the old copy.

Any thoughts?

 

[Kevin3NF]

Make a copy of your db and store it somewhere safe. Make a new database and
try to import all of the object from the 'corrupt' database into the new db.
If that doesn't work, download and run Jetcomp
(http://support.microsoft.com/default.aspx?scid=kb;en-us;273956&Product=acc)
utility.

Also, this may be a good time to re-visit your backup plan for this db.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Tony Toews]

A database we are using in access 97 returns a message
that it needs to be repaired upon opening. When we select
the repair option, it says that it is invalid and cannot
be repaired.

In addition to Kevin's suggestion you can visit the Access Corruption
FAQ at my website for some more ideas.

We have a 2-month old copy of the database that functions,
but the data tables are not up to date. This has happened
a few times before, but we were able to repair the
database temporarily (it would only work once and then ask
to be repaired each time upon opening) and extract the
data tables and paste them into the old copy.

Peter Miller has stated that you should always import all objects in a
repaired MDB into a new MDB as there may be minor corruption still
left which can get worse over time.

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