Easily compare data and code differences between two Access databases.
"I have written over 60 access programs and I work on about 10 different ones at any given time. I make different changes to the same application on multiple client sites. In the past, trying to walk each application to check on changes from each site was not only time consuming but was a nightmare. With AccessDiff I have spent about 4 hours in the last 30 days keeping track of the differences in my applications, where in the past I would have spent better than 40 hours. I am extremely happy with the ease of use of your program as well as how fast it brings back the results. I cannot imagine how I ever got along without it."
Easily compare access databases with AccessDiff. AccessDiff can compare two databases, two objects within a database, or two folders of databases. It also detects missing objects in either the source or destination. Records are compared based on the primary key. If there is no primary key for a table, the comparison is performed on the Natural Key. After the database comparison is performed, the differences can be exported into several different formats. Download the full list of features.
Compare Access Databases For The Following Microsoft Accesstm Database Versions
AccessDiff supports Access 2000, 2002, 2003, 2007, 2010 32 bit, 2010 64 bit, 2013 32 bit and 2013 64 bit databases. When comparing Access databases you must have an Access version installed on your machine equal to or higher than the Access database you are trying to compare. For example, if you have Access 2003 installed on your system you cannot compare Access 2007 or higher databases.
|Compare Toolbars and Menu Bars||All custom toolbars and menu bars are compared. The properties of individual command buttons are compared.|
|Compare Forms||All visual elements of the form are compared. The code module if any is compared. AccessDiff automatically ignores any white space differences. Missing tables and queries are automatically detected and logged.|
|Compare Reports||All visual elements of the report are compared. The code module if any is compared. AccessDiff automatically ignores any white space differences. Missing tables and queries are automatically detected and logged.|
|Compare Macros||All properties and commands of the macro are compared.|
|Compare Modules||The full text of the module is compared. AccessDiff automatically ignores any white space differences.|
|Compare References||Detects broken references. Detects version differences. Detects missing references between the source and destination databases.|
|Compare Data Access Pages||All elements are compared.|
|Compare Table Relationships||All relationships between tables are compared. All properties of the relationships are compared.|
|Compare Table/Field Definitions||Compares the existence or non-existence of tables between the source and destination databases and all field definitions.Detects column property differences. Detects table index differences.|
|Compare Queries||The SQL between the source and destination databases are compared. AccessDiff automatically ignores any white space differences. Missing tables and subqueries are automatically detected and logged.|
|Compare Records||Detects all record differences based on the primary key. If there is no primary key for a table, the comparison is performed on the user chosen Natural Key.|
|Compare ADP (Access Database Projects)||Compares SQL Server Tables, Stored Procedures, Functions and Views.|
|Compare Snippets||Compares two code snipets.|
|Word Difference Highlighting||Highlights word differences during code comparison.|
|Startup Forms||Supports startup forms and AutoExec macros.|
|Table Data Differences||Table data difference report.|
|Command Line Interface||Compare two databases with the default options and export a report.|
|Custom Exclusions||Exclude specific fields from the comparision or specific text when comparing modules.|
|Documentation||Industry standard formatted help is included.|
|1 Year Free Upgrades||Purchase today and all upgrades are free for the next year.|
|60 Day Money Back Guarantee||At Kellerman Software, we want you to be totally satisfied with your purchase. Receive a refund within 60 days when ordering from KellermanSoftware.com. Source code versions are non-refundable due to their nature.|
|Lifetime Support||Lifetime E-mail technical support is included.|
How does the AccessDiff stack up against the competition?
Download a free 30 day trial today.
- Full working version
- Includes technical support
- Works with Access 2000, 2003, 2007, 2010, and 2013
"AccessDiff solved for us the problem of there being no really workable source code control for Microsoft Access, in an environment where there is extensive work in Access by multiple developers. We can now easily pinpoint changes to code and data objects for evaluation and review. The quality of our products delivered to customers has taken a noticeably risen as a result of using AccessDiff."
Richard Berman, Development Directory, RBAC, Inc.
When using AccessDiff to compare Access databases you must meet the following system requirements.
- Microsoft Access 2000, 2002, 2003, 2007, 2010 32 bit, 2010 64 bit, 2013 32 bit or 2013 64 bit.
- Windows 98 SE, Windows 2000 with SP4, Windows ME, Windows XP with SP2, Windows 7, Windows 8, Windows 10, Windows 2000 Server with SP4, Windows Server 2003, Windows Server 2008, Windows Server 2012, or Windows Server 2016
- Pentium II or higher.
- 64MB RAM
- 15 MB Hard Disk Space
"AccessDiff provides us with an invaluable tool for managing MS Access databases. It now forms an integral part of our Version Control and Change Management procedures, ensuring only the changes we intended are included in each release of a MS Access application. Without it, you can never be quite sure."
CompuEase Consulting Services
- Simply choose the databases to compare.
- Choose which items to compare on the advanced tab.
- View the report of the differences
"We were engaged by a client to help them migrate off a proprietary accounting system built on Visual Basic 6.0 and an Access 2000 database. AccessDiff made it simple for us to understand how the data flowed through the system, and reduced the amount of time we had to spend digging through code to understand the business rules built into the proprietary system."
Q: How do I use my license key?
A: In the help menu click Register, enter your user name and license key and then restart AccessDiff. If you are using Access 2007; click on the Add Ins Tab then click Register on the Help Menu.
Q: I lost my license key how do I retrieve it?
A: Go to your account
Q: I lost my software how do I retrieve it?
A: Go to downloads
Q: Where can I download the latest version of my software?
A: Click the download tab.
Q: AccessDiff acts like it is still in trial mode even after I entered the user name and license key.
A: Restart AccessDiff
Q: When I run AccessDiff all that is shown is the Access Menu
A: The macro trust Settings in MS Access are set to not allow macros to run at all. Go into the Trust Center in MS Access, select macros, select enable all macros.
Q: Can AccessDiff compare Access 97 Databases?
A: AccessDiff handles Access 2000 databases or higher. To compare Access 97 databases, convert the database to a newer version before comparing.
Q: What is the maximum limit that AccessDiff can compare?
A: The limit is imposed by Microsoft Access, there can be a maximum of 2GB of differences between the two databases that are compared.
Q: I am using AccessDiff with Access 2007 and getting the message: "The digital signature has been tampered with." How do I get around this?
A: Make sure you download and install the latest version of AccessDiff. After installation, double click on AccessDiff for Access 2007.accdc where you installed AccessDiff. This will install a digitally signed file specifically associated for your machine.
Q: I am having trouble getting AccessDiff to run because of security issues. How do I get around this?
A: Access macro security is set too high. Change the security settings:
- On the menu, go to File - Options
- Choose Trust Center
- Click on Trust Center Settings
- Click on Macro Settings
- Click on Enable All Macros
|11/28/2005||1.0||Initial Release. Key features include intelligent VBA code comparison and being extremely easy to use.|
|9/14/2006||1.13||New features include; an enhanced code comparison screen, detection of corrupt databases, handling of broken relationships, and handling of broken external links.|
|11/11/2006||1.16||AccessDiff now includes more robust handling of composite keys.|
|5/5/2007||2.0.22||By customer request, this update to AccessDiff allows the selection of individual items to compare that exist in both databases. These features were also added; detection of missing tables in sub queries, detection of missing tables/queries for reports, and detectiion of missing tables/queries for forms.|
|5/12/2007||2.0.25||AccessDiff is now compatible with Access 2007. This update also fixes date formatting issues for German and French customers. U.S. customers are unaffected by this change. Many thanks go out to Arnaud Forster in France and Axel Wegner in Germany for helping us resolve this issue.|
|7/26/2007||2.0.28||This update fixes the "Digital Signature has been tampered with" message when running under Access 2007.|
|9/20/2007||2.0.34||This update fixes several minor issues including, German Date Formatting, Overflow Message, Menu Difference Report, and Access 2007 ADO reference changed message.|
|2/20/2008||2.0.40||This update includeds support for Unicode languages such as Chinese, Japanse, and Russian.|
|7/13/2008||3.0||AccessDiff now includes the ability to compare tables with no primary key by the Natural Key. AccessDiff can also compare ADP (Access Database Projects) and the underlying SQL Server tables, stored procedures, functions, and views.|
|8/4/2008||3.1.7||This update includes major performance enhancements including twice the speed for reports, forms, and modules. Record comparison has been improved by over 120%.|
|9/13/2008||3.1.14||This is a critical update for ODBC and ADP users. AccessDiff now detects deleted tables for non SQL Server ODBC Linked Tables. AccessDiff also detects broken connections for ADP databases.|
|9/18/2008||3.1.16||This is a critical update for Access 2007 users which fixes the widespread form timer issue.|
|10/11/2008||3.1.25||AccessDiff now supports simultaneous versions of Access installed. It also now supports MySQL linked tables. The open form timer issue with Access 2007 and a slow PC has been fixed. Several other cosmetic issues were fixed.|
|5/30/2009||3.1.35||These minor fixes were implemented; handling for unicode characters in memo fields, improved form property comparison, corrupted reference comparisons.|
|5/10/2010||3.1.42||By customer request, there is now an option to ignore form filters when comparing forms. See the advanced tab.|
|7/9/2010||3.1.43||This update fixes a small issue with composite key relationship comparisons.|
|12/31/2010||3.1.46||This update fixes a small issue when creating a large number data access pages and then deleting them. It also fixes an issue with remote security files.|
|2/22/2011||4.0||New features include: compatibility with Access 2010, compatibility with Windows 7 64 bit, command line interface for running comparisons, ability to exclude fields per table or per database, exporting differences to PDF, exporting differences to CSV, exporting differences to HTML.|
|2/24/2011||4.0.01||This update fixes the Error 3021, No Current Record that was due to the new Excluded Fields feature.|
|8/2/2011||4.05||By customer request, the advanced options tab now has the ability to only compare linked tables, or only compare local tables between Access Databases. This update also fixes issues when comparing reports with French characters in report names, and not comparing queries due security changes in MS Access from the latest MS Office Service Pack.|
|3/8/2012||4.0.06||AccessDiff is now compatible with MS Access 2010 SP1. A minor defect was also fixed where report differences were shown where one report was opened with view code and one report was not by a user.|
|8/18/2012||4.0.08||A defect when selecting items to compare under Access 2003 was fixed. No other Access Versions are affected.|
|6/1/2013||5.0||New features include, compatibility with MS Access 2013, comparing two objects within the same database, ability to compare folders, the ability to compare folders on the command line, the ability to exclude text when comparing modules, and enhanced code comparison.|
|7/1/2013||5.0.1||This update fixes an issue when AccessDiff is run for the first time and the Differences button is clicked before the Compare button.|
|7/16/2013||5.0.2||This update fixes an issue when browsing for *.accdb files with Access 2007 or higher.|
|10/19/2014||5.0.3||Support for single licensing for Gold Suite Customers.|