Recovery of data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jk - 02 Dec 2004 15:23 GMT

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

Reply to this Message

Armen Stein - 02 Dec 2004 16:57 GMT

> Hi,
>
[quoted text clipped - 3 lines]
>
> 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.

Signature

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

Reply to this Message

John Vinson - 02 Dec 2004 18:28 GMT

>Hi,
>
[quoted text clipped - 3 lines]
>
>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

Reply to this Message