Download AccdbMerge
AccdbMerge compares two Microsoft Access database files and shows differences in tables, queries, forms, reports, macros, and modules. The program processes both .mdb and .accdb formats, including compiled .mde and .accde files. Data comparison works at the row level with key field detection for new, deleted, and changed records. Custom mappings handle cases where table and column names differ between files. Batch operations allow multiple tables to be checked in one run.
The software includes export options for Xlsx and Json formats, so results can be reviewed in spreadsheet applications or processed by other tools. Saved diff profiles store all comparison settings for reuse in recurring tasks. Password-protected Access files can be opened directly. A command line version handles data-only automation for scheduled comparisons. The standard edition uses a perpetual license with a 14-day trial period, and a free version offers limited sessions without signup or telemetry.
AccdbMerge targets database developers and administrators who maintain multiple copies of Access applications. The tool identifies schema drift between development, testing, and production versions. Its data differencing prevents duplicate records when consolidating files. Support covers Access 2007 through 2024 and Microsoft 365. The interface displays two database projects side by side with checkboxes for selecting objects to include in the comparison. This selection control lets users narrow the diff scope to relevant tables or queries, which is especially useful for large databases with many objects.
Use Cases for AccdbMerge
| Detects structural differences between two Access files | Compares table schemas queries forms and modules |
| Identifies new deleted and changed rows precisely | Shows which records exist in only one file |
| Diffs results from custom SQL query outputs | Compares logical data despite differing table schemas |
| Maps tables and columns with different names | Compares fields storing same information differently |
| Processes multiple objects in single diff session | Produces consolidated report across selected tables |
| Defines filtered subsets within batch comparison | Reduces processing time for large table portions |
| Exports difference results to spreadsheet or JSON | Enables filtering sorting and programmatic processing |
| Saves comparison configuration for repeated use | Loads profiles for recurring synchronization tasks |
| Opens password-protected Access database files | Stores credentials within saved project sessions |
| Searches within large difference result sets | Locates specific table names or data values |
| Compares and merges indexes and relationships separately | Applies primary key changes between databases |
| Automates data comparison without graphical interface | Runs scheduled tasks via command line arguments |