Compare'EM is described as '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'. There are seven alternatives to Compare'EM for Windows. The best alternative is SQL Data Compare. It's not free, so if you're looking for a free alternative, you could try CompareData or StarInix Database Compare. Other great apps like Compare'EM are DataWeigher (Paid), Replicator (Paid), Data Compare SQL (Paid) and AccessDiff (Paid).
The DataWeigher is the tool to compare and synchronize data. You can select any tables and fields from two MS Access databases and the DataWeigher finds differences. The comparison result is very visual, each type of records (added, deleted, changed) has its own color.
Whether you need to simply compare two databases or set up replication, you have come to the right place. Replicator does not change the reference database in any way nor requires setting up customs agents or triggers in your databases.
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.
Easily compare access databases with AccessDiff. AccessDiff compares objects with the same name between two Access databases. It also detects missing objects in either the source or destination. Records are compared based on the primary key.