Access corrupted Data

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.
 
J

John Vinson

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.
 
B

BellSouth User

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing Access MDB or Accdb with client using older or newer version of Office 1
Creating a Search using a combo box and then creating a report. 4
Dynamic Naming of Form Button 3
Blank Page After Envelope-Label Wizard 5
Access Lock File .LACCDB / Now shows as a notepad file 0
Using project as a resource tracker 0
Help creating a search form in Access XP 0
Visio 2019 crashes when attempting to open drawing. 0

Top