Do I need a Microsoft Access® license on every machine I install Catalyst?

If you install the Access Runtime, you will not need a licensed copy of Microsoft® Access on each machine. The Access Runtime is available for free download from the Catalyst evaluation download page. If you plan to modify Catalyst, you will need the Full Edition of Catalyst and at least one licensed copy of Microsoft Access.

Back to Top

How do I avoid the security warning when opening Catalyst with Access 2003?

Microsoft Access® 2003 employs what it refers to as "sandbox" mode to block macros and code that may harm your computer. To avoid the security warning, it is necessary to either turn-off sandbox mode or code-sign the front-end database with a digital certificate. All Basic Editions are digitally signed with a code-signing certificate; however, all Full Editions of the software are not digitally-signed to enable users to customize the front-end database.

To avoid the security warning with Full Editions of the software, you can turn-off sandbox mode by changing the macro security setting to Low or use another version of Microsoft Access. If you do not intend to modify the front-end database, you can request a code-signed database by contacting Catalyst Manufacturing Support. If you have customized the front-end database, this service is provided at a nominal fee.

When first opening a digitally signed database Microsoft Access 2003, you will be prompted with a security warning indicating "This file has been digitally signed by Catalyst Manufacturing. Do you want to open this file or cancel the operation?" Prior to clicking the Open button, mark the checkbox "Always trust files from this publisher and open them automatically". This will install the digital certificate in your list of Trusted Publishers so the security warning is not displayed the next time you open Catalyst.

Back to Top

How do I setup Trusted Locations in Microsoft Access 2007?

In Access 2007, you will need to add the Catalyst path as a Trusted Location as described below.

1. Open Access 2007 and select the Microsoft Office program icon in the upper-left corner of the application. Select the 'Access Options' button at the bottom of the screen.

2. On the Access Options screen, select the Trust Center option from the left pane.

3. Under the Microsoft Office Access Trust Center heading, select the 'Trust Center Settings' button.

4. On the Trust Center screen, select Trusted Locations from the left pane.

5. Select the 'Add new location' button at the bottom of the screen.

6. Browse and add the Catalyst application to the 'Path' field. Select the check box 'Subfolders of this location are also trusted'. Select the OK button to add the new location.

7. Select the OK button twice to close the Trust Center and Access options screens.

Back to Top

How do I setup Trusted Locations if I'm using the Access Runtime?

Unfortunately, the Access 2007 or Access 2010  Runtime versions do not provide the Access Options screen to establish Trusted Locations directly. To establish Trusted Locations using the Access Runtime, please refer to the steps below. 

1. Using Windows Explorer, browse to the C:\Program Files\Catalyst folder on the client PC. For Windows 64-bit machines, browse to the C:\Program Files (x86)\Catalyst folder.

2. Locate the CreateTrustedLocation_CatalystMFG.reg file in the Catalyst folder, right-click the file, and select Edit or Open with > Notepad from the shortcut menu to open the file in edit mode.

3. If using the Access 2007 Runtime, change "14.0" to "12.0" in the HKEY_CURRENT_USER line. If using a Windows 64-bit machine, change "C:\\Program Files\\Catalyst\\" to "C:\\Program Files (x86)\\Catalyst\\" on the last line.

4. Close and save changes made to the CreateTrustedLocation_CatalystMFG.reg file.

5. Double-click the file to run and update the registry and establish the Catalyst folder as a Trusted Location. You must be logged in as a system administrator to make registry changes.

Back to Top