AccessDiff has the ability to compare databases or folders of databases using the console or a batch file. You will first need to find where you have installed AccessDiff and also the path to Microsoft Access before proceeding. Use the version of AccessDiff that is appropriate for the version of Microsoft Acccess that you have installed. Microsoft Access takes in command line parameters using a single quoted string.
How do I tell if it ran successfully?
- Delete the output report, the command line log, and the error log before starting. If the output report does not exist then there was a problem.
Basic Format:
"Path to Microsoft Access" "Path to AccessDiff" /cmd "Command Line Parameters"
Example for Access 2010 with Windows 7:
"C:\Program Files\Microsoft Office\Office14\Msaccess.exe" "C:\Users\John Smith\AppData\Roaming\AccessDiff\AccessDiff for Access 2010.accde" /cmd "SOURCE=C:\Regression1.mdb;DESTINATION=C:\Regression2.mdb;EXPORTTYPE=PDF;REPORT=C:\MyReport.pdf"
- Notice that the path to AccessDiff is in the current logged in user application data directory.
- SOURCE - This is the path to the source database or folder to be compared. When comparing a folder, wildcard patterns are allowed.
- DESTINATION - This is the path to the destination database or folder to be compared. When comparing a folder, wildcard patterns are allowed.
- EXPORTTYPE - This is the output format for the detailed differnces report. Valid values are Word, Excel, CSV, HTML, and PDF. PDF is only available in AccessDiff 2007 and higher.
- REPORT - This is the output path for the report file.
Command Line Output
- AccessDiffCommandLineLog.txt - This file is created in the directory where AccessDiff is installed. Debugging and validation messages are created here.
- AccessDiffErrorLog.txt - This file is created in the directory where AccessDiff is installed if an exception occurs.