compare & find differences between two MS ACCESS database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everyone,

I am a developer & wanted to compare & find the differences between two
MS-ACCESS databases.The comparison results should be a report which
essentially shows DATA/record diferences in each table for the 2 databases.

Do you know how this can be done OR can you suggest any 3-rd party tools
which supports developer plug-in/component that I can use within my
application?

Pls help

Thanks
Lakshmi
 
Hi Brendan Reynolds,

Thanks for your reply. I just contacted FMS. Their reply is as follows.

"No part"
1. It's licensed on a per user basis. That means if you are distributing an
application with Total Access Detective, each user that uses it must have a
license.

2. There is no runtime component with this product nor a way to pass paths
and files to it programmatically or through command line parameters.

"Yes" part:
1. The results are in tables which you can programmatically open and display
in any manner you choose. While there is no documentation for the table
structures (nor is it something that FMS, Inc would be able to support), this
is certainly possible.

Do you know any other tool that can Solve my puzzle/

Thanks
lakshmi
 
Sorry, no. If you only want to compare differences in data, it would not be
difficult to do it yourself. First you need queries to show records in Table
A that are not in Table B, and records in Table B that are not in Table A.
The Find Unmatched Query Wizard will take care of that for you. Then you'd
need to open two recordsets (one for each table) to step through the records
that do exist in both tables, and compare the values of each field to
determine if there are differences between the two tables. Repeat for each
pair of tables. A tedious chore, but not technically difficult.
 
Back
Top