Recovery of data

[jk]

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

 

[Armen Stein]

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

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

 

[John Vinson]

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

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