Access corrupted Data

  • Thread starter Thread starter Daman
  • Start date Start date
D

Daman

My database got corrupted. I have two coppies of the
database. One is 5 days older. Is there a way to compare
the two database for any changes made to records in the
database.
Any help or comment will be greatly appreciated.
 
My database got corrupted. I have two coppies of the
database. One is 5 days older. Is there a way to compare
the two database for any changes made to records in the
database.
Any help or comment will be greatly appreciated.
Click to expand...

You can use File... Get External Data... Link to link the tables in
one database to those in the other - Access will append a 1 to each
table name.

Then you can compare the sizes of the tables and/or use the Unmatched
Query Wizard to compare the contents of the tables.
 
You can create a "Find unmatched query" on the Query tab. Just click on New
and follow the instructions.
This wizard creates a query that finds records in one table that have no
related records on another table.
Do not hesitate to reply to this message if you need more help.

C.A. Hernández
Deerfield Beach FL
(e-mail address removed)
 
Back
Top