Repairing Database

  • Thread starter Thread starter Mark
  • Start date Start date
M

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

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.
Click to expand...

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