Recovery of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

In the event of a corrupt database(like now), how do you recover the records
from the several tables within that database and transfer those records to a
new database with the same structure?

thanks
 
Hi,

In the event of a corrupt database(like now), how do you recover the records
from the several tables within that database and transfer those records to a
new database with the same structure?

thanks
Click to expand...

If the database is corrupted beyond the ability of compact and repair to
fix, then you might not be able to recover any of the data. You can
attempt to link to individual tables in the corrupt database from
another database to see if you can read any of the data. If you can,
then you could build an append query to copy the data into a table in
another database. This technique usually fails, but it's worth a quick
try.

Make sure you have the latest versions of Access and Jet, as there are
sometimes improvements in the compact/repair code.

--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com
 
Hi,

In the event of a corrupt database(like now), how do you recover the records
from the several tables within that database and transfer those records to a
new database with the same structure?

thanks
Click to expand...

It's sometimes as easy as creating a new database and using File...
Get External Data... Import; and it's sometimes impossible. It can be
anywhere in between.

Check out Tony's Corruption FAQ at

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

for suggestions and links.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top