Version 5.9
In this Topic: Show
The purpose of this topic is to report any issues that the customer should be aware of before installing the Order Manager on a workstation which also has MS Office/MS Access 2007 installed.
Users may experience problems when using the Order Manager ALT and letter key combinations to "click" a control on a form when Access 2010 or Access 2007 are installed, due to changes that have been made in MS Access. For example, at the Manual Orders screen, the key combination of "ALT" plus the letter "M" will cause the Line Items tab to be opened.
There are known compatibility issues with Access 97 format database files and Access 2007. It is advisable to convert databases in Access 97 format to a more recent format (Access 2002-2003).
If serious slowness is encountered while searching for, approving orders, or editing addresses at the (View) Orders screen, check to see if the Microsoft Access 2007 ribbon has been minimized or hidden. Minimizing the ribbon has improved the performance of the program for several of our customers. Users can select whether or not to hide the ribbon that shows Microsoft Access functions by clicking the down arrow as shown in the image below and checking or un-checking Minimize the Ribbon in the drop-down list.
Figure 1: MS Access - locating the ribbon
Microsoft Access 2007, by default, is installed with a high level of macro security that can interfere with the execution of code in many MS Access-based applications, such as the Order Manager. To ensure that the Order Manager, Product Manager, or Ecom Assembler will run smoothly with Access 2007, follow the steps below BEFORE installing the Order Manager or other Stone Edge software!
By taking the following measures, you will avoid a common failure during the installation of the Order Manager, which due to the default macro security setting in Access 2007, causes the installer to "freeze" and a leave a partial installation of the Order Manager.
Once Access is installed on your computer, download Microsoft Service Pack 2 for Office 2007 and follow the instructions within the Microsoft documentation to install the service pack. (This is a large file and takes a few minutes to download.)
Restart your computer after installing the service pack.
Open Microsoft Access. Click the round Office button in the top left corner.
Figure 2: MS Access - accessing the Access settings
In the window that opens, click the [Access Options] button at the bottom.
Figure 3: MS Access - selecting the Access Options
In the Access Options window, click the [Trust Center] button on the left navigation bar.
Figure 4: MS Access - opening the Trust Center screen
Then on the next page that opens, click the [Trust Center Settings] button in the lower right section of the page.
Figure 5: MS Access - at the Trust Center screen, open the Trust Center Settings screen
In the Trust Center window, click the [Macro Settings] button on the left navigation bar. (The default Macro Setting in Access 2007 is either the second or third option.)
Figure 6: MS Access - Trust Center Settings screen, Macro Settings
Choose the [Enable all macros] option (lowest macro security level) in the Macro Settings list.
Figure 7: MS Access - Macro Settings, enabling all macros
Click [OK] and close out of Access. You can now install the Order Manager on this computer.
Go to Top