Access 2007 Notes

Support for Access 2007 begins with Version 5.5 of the Order Manager. For more information about the changes between Access 2003 and Access 2007 refer to Microsoft's web site.  

Considerations

• 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.

Microsoft Access 2007 Speed Issues

If serious slowness is encountered while searching for, approving orders or editing addresses at View Orders in Order Manager Version 5.9, 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.

Microsoft Access Security Issues

Microsoft Access 2007, by default, is installed with a high level of macro security that can interfere with the execution of code in many 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.

1. 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.)

2. Restart your computer after installing the service pack.

3. Open Microsoft Access. Click the round Windows button in the top left corner.

4. In the window that opens, click the Access Options button at the bottom.

5. In the Access Options window, click the Trust Center button on the left navigation bar.

6. Then on the next page that opens, click the Trust Center Settings button in the lower right section of the page.

7. 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.)

8. Choose the Enable all macros option (lowest macro security level) in the Macro Settings list.

9. Click OK and close out of Access. You can now install the Order Manager on this computer.

Created 5/22/09

Updated 9/29/09

Modified 11/14/11