Compare two MDB or TABLES

[DREAMER]

Hello Everybody!

I need to compare two MDB or two TABLES in order to know what record are new, and what record were modified with respect to a previous MDB ....

Thanks!!

Dreamer.-

 

[Larry Linson]

Hello Everybody!

I need to compare two MDB or two
TABLES in order to know what record
are new, and what record were modified
with respect to a previous MDB ....

Link the Tables from one into the other, create queries joining the tables
with outer joins and use the criteria Null for one... that will tell you
Records that were added. Make the join the other way, and use the criteria
Null under that field to tell which were deleted.

It gets more complicated if you want to look for differences in the content
of records. FMS, Inc. has a commercial compare software package -- you can
check their website, http://www.fmsinc.com, to see if it suits your needs
and is in your price range. There may be freeware or shareware tools, but
you'd need to Google for them, as I don't know where to suggest for this
particular functionality.

Larry Linson
Microsoft Access MVP

 

[Dreamer]

Thank you Larry!!

Hello Everybody!



Link the Tables from one into the other, create queries joining the tables
with outer joins and use the criteria Null for one... that will tell you
Records that were added. Make the join the other way, and use the
criteria Null under that field to tell which were deleted.

It gets more complicated if you want to look for differences in the
content of records. FMS, Inc. has a commercial compare software package --
you can check their website, http://www.fmsinc.com, to see if it suits
your needs and is in your price range. There may be freeware or shareware
tools, but you'd need to Google for them, as I don't know where to suggest
for this particular functionality.

Larry Linson
Microsoft Access MVP