Comparing Databases

  • Thread starter Thread starter LPS
  • Start date Start date
L

LPS

Is there a way that two databases can be compared, record
by record, to find out if there are any duplications
between the two?

We are using Access 97.

Thanks,
LPS
 
Linda: By databases, do you mean tables? If so, create a
key in each table containing the fields (in the exact
same order and size) that you want to compare. Build a
new query and show both tables. Create an inner join on
the keys if it is not already there and select * fields
from both tables to show. Execute the query and any
identical records/keys should show up.

GRayL
 
I'm got a client that wants me to do double entry and then verify the data. It sounds like the same things this person wants to do, accept I have Access 2003. Would it be done the same way in Access 2003?
Michelle
 
Back
Top