Total Access Detective finds the differences between any two objects in one Microsoft Access database, including fields, controls, properties, macro lines, module code, and data.
Can I compare Access Data Projects (ADP files) with Total Access Detective?
Yes. Access Data Projects connect directly to a SQL Server database and let you use Access objects (forms, reports, macros, modules, and command bars) against the tables, views, stored procedures, etc. defined in the SQL Server database.
Total Access Detective lets you compare the Microsoft Access objects contained in your ADPs for differences. It cannot compare the SQL Server objects between two ADPs because it's not connected to your SQL Server databases to "see" them.
To compare SQL Server tables and their data from an ADP, run the Total Access Detective add-in when you have your ADP open. That will let you select the tables to compare.
If you need to compare data between two SQL Server databases, create an Access ACCDB or MDB file, then link to the two tables. Run the Total Access Detective add-in to compare them.
Please sign in to leave a comment.