Total Access Detective finds the differences between any two objects in one Microsoft Access database, including fields, controls, properties, macro lines, module code, and data.
Why should I not install Microsoft Access Add-ins and Databases in the Program Files Folder?
Installation Folder Background
Years ago, our setup programs defaulted to install itself in the C:\Program Files folder since that was Microsoft's recommended location for installing software. However, our more recent setup programs intentionally prevent installation in that folder. This is because Microsoft has made directories in the Program Files folder READONLY ever since Windows Vista. To prevent viruses that attacked and modified program files like EXE files, Windows prevents files in that folder from changing. It doesn't matter if you have administrator permissions.
Problem for Microsoft Access Add-ins and Databases
This poses a problem for our Microsoft Access add-in products or any Access databases you install. Unlike an EXE file, Access add-ins are Access databases. Though we ship our add-ins as ACCDE or MDE files so that the code can't change, they still change to store new data and link to tables in other databases. When installed in the Program Files folder, these modifications are not allowed and unexpected errors may arise.
For example, this error may be triggered in Total Access Detective if the program is installed in a READONLY folder: Error 91: Object variable or With block variable not set
Our products now avoid this problem by not allowing installation in the Program Files folder and installs by default in on one of two places:
- If installing for yourself (user installation), it defaults to your private Users folder
- For Machine installation, it defaults to a folder on your C: drive, which you need to ensure you have READ/WRITE rights
If you are installing one of our older versions, be sure to override the default Program Files folder and select a folder where you have WRITE permissions after installation.