AccessDiff

AccessDiff: Compare Microsoft Access Databases

Open source tool for comparing Microsoft Access databases, highlighting differences in tables, queries, forms, reports, macros, and modules

What is AccessDiff?

AccessDiff is an open source diff tool used specifically for comparing Microsoft Access database files. It provides a graphical interface that allows you to easily compare two Access .mdb or .accdb files and see the differences between them at various levels.

At the highest level, AccessDiff compares the database objects between the two Access files being compared. This includes tables, queries, forms, reports, macros and modules. It flags any objects that have been added, removed or changed.

Drilling down further, you can compare the details within each object. For example, for a table it shows differences in columns added or removed as well as data differences row by row. Similar details are provided for differences in queries, forms, reports, etc.

Some key features include:

• - Compare two Access databases (.mdb or .accdb files)
• - See differences in database objects like tables, queries, forms, reports, macros and modules
• - Drill-down to see specifics on data and structural differences within each object type
• - Use built-in graphical diff viewer or text-based diffs
• - Output differences to HTML or text files
• - Command line mode available for automation
• - Handle comparisons across .mdb and .accdb formats

AccessDiff provides an easy way to get a high-level overview of the differences between two Access databases as well as drilling into the specifics. It can be helpful for migrations, tracking changes, documentation, and more.

AccessDiff Features

Official Links