Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have two Access databases that I need to compare but I don't know how I can do this.

I'm trying to compare the differences between both the structure and content (possibly limiting the comparison to tables and queries). Is this possible?

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

Below are three free products that might help.

Free Database Compare 2.0 :

The StarInix Database Compare application will allow you to compare the structure of two databases and display all the differences between them. Supported databases include: SQL Server (All Editions), MySQL and Access databases. You can compare two different databases, like access and SQL 2000. It will also allow you to create snapshots of a database and compare a live database to an snapshot. A database structure viewer is included.

Compare'EM Lite

A very simple to use utility to analyze a pair of related Microsoft Access databases, determine what has changed from one to the other, and generate VBA code to propagate those changes.

Total Access Analyzer

Total Access Analyzer examines all your database objects to provide extensive documentation, cross-reference, and application and flow diagrams, with over 350 presentation-quality reports.

share|improve this answer
    
Total Access Analyzer did not used to be free. Is that changed now? –  David W. Fenton Dec 19 '09 at 4:17
    
@David: You're right - this is an error. Only a demo is available and the limitations aren't well explained, but I suspect it doesn't do much. –  harrymc Dec 19 '09 at 7:05
    
CompareEm Lite sounded awesome, but it sucks. More than one column involved in a relation? Chokes. Also, good luck figuring out how to enter your password to use it. –  tbone May 28 '12 at 23:17
    
Neither Free Database Compare 2.0 or Compare'EM Lite allow you to compare .accdb files. They are both apparently hardcoded for .mdb files. –  HK1 Jan 15 at 14:52
add comment

Another product that may work for you:

DB Weigher

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.