|
|
| Line 5: |
Line 5: |
| On some machines, ODBClink opens but doesn't start. On others, ODBClink opens but shows a compile error. Adding a trusted location in Microsoft Excel normally resolves these two problems. | | On some machines, ODBClink opens but doesn't start. On others, ODBClink opens but shows a compile error. Adding a trusted location in Microsoft Excel normally resolves these two problems. |
|
| |
|
| == Adding a Trusted Location in Microsoft Excel 2007 ==
| | #'''[[Adding a Trusted Location in Microsoft Excel 2007]]'''; |
|
| |
|
| [[File:AddTrustedLocationExcel2007.png|300px|thumb|right|Adding a trusted location in Microsoft Excel 2007]] | | #'''[[Adding a Trusted Location in Microsoft Excel 2010 or 201]]'''; |
|
| |
|
| # Start '''Microsoft Excel''';
| |
| # Click on the '''Round Office''' button;
| |
| # Click on the '''Excel Options''' button;
| |
| # Click on the '''Trust Center''' entry in the list on the Excel Options dialogue;
| |
| # Click on the '''Trust Center Settings...''' button;
| |
| # Click on the '''Trusted Locations''' entry in the list on the Trust Center dialogue;
| |
| # If ODBClink is installed on a network, tick the '''Allow Trusted Locations on my network''' option;
| |
| # Click on the '''Add new location...''' button;
| |
| # Click the '''Browse...''' button and select the folder where ODBClink is installed'
| |
| # Tick the '''Subfolders of this location are also trusted''' checkbox;
| |
| # Click OK to add the trusted location;
| |
| # Click on the '''OK''' button of the Trust Center dialogue;
| |
| # Click on the '''OK''' button of the Excel Options dialogue;
| |
| # Close '''Microsoft Excel''';
| |
|
| |
| Once the Trusted Location has been added you should be able to start ODBClink . However, we do recommend you ensure no disabled items have been added. See [[Compile error due to disabled items]] for more information.
| |
|
| |
| == Adding a Trusted Location in Microsoft Excel 2010 or 2013 ==
| |
|
| |
| [[File:AddTrustedLocationExcel2013.png|300px|thumb|right|Adding a trusted location in Microsoft Excel 2010 or 2013]]
| |
|
| |
| # Start '''Microsoft Excel''';
| |
| # Click on the '''File''' button;
| |
| # Click on the '''Options''' entry in the list;
| |
| # Click on the '''Trust Center''' entry in the list on the Excel Options dialogue;
| |
| # Click on the '''Trust Center Settings...''' button;
| |
| # Click on the '''Trusted Locations''' entry in the list on the Trust Center dialogue;
| |
| # If ODBClink is installed on a network, tick the '''Allow Trusted Locations on my network''' option;
| |
| # Click on the '''Add new location...''' button;
| |
| # Click the '''Browse...''' button and select the folder where ODBClink is installed'
| |
| # Tick the '''Subfolders of this location are also trusted''' checkbox;
| |
| # Click OK to add the trusted location;
| |
| # Click on the '''OK''' button of the Trust Center dialogue;
| |
| # Click on the '''OK''' button of the Excel Options dialogue;
| |
| # Close '''Microsoft Excel''';
| |
|
| |
| Once the Trusted Location has been added you should be able to start ODBClink . However, we do recommend you ensure no disabled items have been added. See [[Compile error due to disabled items]] for more information.
| |
|
| |
|
| == Related Topics == | | == Related Topics == |
|
| |
|
| * [[Troubleshooting Start-Up Problems]] | | * [[Troubleshooting Start-Up Problems]] |