MS Access 2013

Contents of this Topic: ShowHide

Overview

The purpose of this topic is to document any known issues that the customer should be aware of prior to installing Stone Edge

For more information about the look and feel changes of MS Access 2013, refer to the Microsoft web site. Be sure to review Microsoft's system requirements before installing the product. Our experience has shown that Microsoft Core XML Services 6.0 is also needed.

Considerations

• Stone Edge requires the use of the 32-bit version of Microsoft Access (or Office) 2013, even for users whose hardware came with a 64-bit operating system installed. If the software is purchased and downloaded directly from Microsoft, the user can choose which version to install at that time. If the software is being installed from a retail DVD, the 32-bit version will be installed by default, even on a 64-bit machine.1  If the 64-bit version of Office 2013 has been pre-installed (bundled with the purchase of the PC), the user must un-install that software and re-install the 32-bit version before attempting to use Stone Edge. Contact the hardware/software provider about its availability.  

• Users may experience problems when using Stone Edge ALT and letter key combinations to "click" a control on a form when Access 2013, 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" causes the Line Items tab to be opened.

• Be sure to install the MS Graph feature of MS Office in order for the Dashboard charts to work properly. If Graphs is not installed, you may get a message stating that the OLE server is not registered. Go to Programs and Features, select Microsoft Office, select Change to rerun the installer to include MS Graph.

1 This information was taken from: http://blogs.technet.com/b/office2013/archive/2013/02/23/understanding-64-bit-office.aspx

Pre-Installation Actions

Prior to installing Stone Edge on a workstation that has Access 2013 installed, the user must change some settings within Microsoft Access:

• Macro Security

• Set the default database type to be an Access .mdb (2003 and lower), not an Access .accdb (2007 and greater), which is the default.  

Setting Macro Security

1. From the File menu, select  Open Other Files.

2. Next, select Options:

2. When the Access Options screen opens, click Trust Center link in the left-hand pane.

3. Then click Trust Center Settings in the right-hand pane.

4. Select Macro Settings from the navigation pane on the left-hand side of the screen.

5. Click Enable all macros radio button and then click OK at the bottom of the page to exit the Trust Center screen and save the new setting.

6. Click OK again to exit the Access Options screen (not pictured).

7. It is now acceptable to install Stone Edge on this workstation.

Setting the Default Database Type

1. From the File menu, select Open Other Files > Options:

The General tab is the default view:

2. Change the setting of Default file format for Blank Database from Access 2007 (.accdb), to Access 2002-2003 (.mdb).

3. Click OK.

MS Access 2010

Created: 12/5/13

Revised: 5/16/14

Published: 09/08/15

Go to Top