Comparing Databases

[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

 

[RobFMS]

FMS Total Access Detective (Demo Available)
http://www.fmsinc.com/products/detective/index.html

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[GRayL]

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

 

[AllForms]

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