Access Database

[GTCobb]

I was wondering what is the best way to clean and repair databases tables
that may have been corrupted. The tables are linked and compact and repair
was unsuccessful on some of the tables. Here is my plan:

1. Re-establish the links
2. compact and repair a tables that have not beein repaired.

Is there any way to repair pointer's in the Access tables without copying
the structures to another table and reloading the data.

 

[John Vinson]

I was wondering what is the best way to clean and repair databases tables
that may have been corrupted. The tables are linked and compact and repair
was unsuccessful on some of the tables. Here is my plan:

1. Re-establish the links
2. compact and repair a tables that have not beein repaired.

Is there any way to repair pointer's in the Access tables without copying
the structures to another table and reloading the data.

Check out the information and links at Tony's FAQ:

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

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