Correct database structure is essential to proper operation of Microsoft Access database applications. A single missing field or incorrect data type can cause an MS Access database to error out or break down, often during a critical process.
Until now, comparing table designs between 2 Access databases was a labor-intensive and tedious process that required an experienced Access professional to get reliable results.
Access Pro is an advanced application designed to easily and accurately identify table design differences between two Access databases. Access Pro will expertly analyze table fields, data types and properties, primary keys and indexes of Access tables. Whether you need to analyze one table or 100 tables, Access Pro will examine the 2 database (.mdb) files and generate a comprehensive report detailing the differences.
Here are some key features of "Access Pro":
· Quickly compare table structures between 2 Access databases
· Easily identify discrepancies and synchronization errors
· Locate and resolve differences in data types that can cause application issues
· Accurately analyze Primary Keys and indexes
· Easily identify discrepancies and synchronization errors
· Determine the latest version of table objects so that they can be merged
· Reduce database clutter by removing unused tables
· Generate clear and concise reporting of Access table differences
· Save money and time by avoiding painful and error-prone manual processes
· Ideal for development to production software release scenarios
Requirements:
· Microsoft Access 2000 or higher
Limitations:
· Lists only the first three differences
· Nag screen
What's New in This Release: [ read full changelog ]
· This version includes Microsoft 2010 compatibility, automated licensing, and optimized discrepancy reporting.
Find us on Google+
