Go to Bottom

 

MS Access 2010 Notes

In this Topic: Show

Overview

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

For more information about the look and feel changes of MS Access 2010, 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.

Warning!

Some of our customers have encountered data problems which are attributed to a problem within Access 2010, which has been reported to Microsoft. Until a service pack is available to correct this, please be aware of the possible causes of data corruption:

AutoNumber fields WILL be reseeded (consistently) to an earlier AutoNumber value during compact & repair in Microsoft Access 2010 in the following instances:

We have NOT been able to repeat this behavior if the AutoNumber is the single field primary key index and the key’s sort is in ascending order!

Considerations

 

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

Pre-Installation Actions

Prior to installing the Order Manager on a workstations that has Access 2010 installed, the user must change some settings within Microsoft Access:

Setting Macro Security

  1. From the [File] Menu, select [Options]:

image399.jpg

Figure 1: c

  1. When the Access Options screen opens, click on the [Trust Center] link in the left-hand pane.

image400.jpg

Figure 2: The Access Options screen, accessing the Trust Center Settings

  1. Then click on the [Trust Center Settings ] button in the right-hand pane.

image401.jpg

Figure 3: The Trust Center screen, accessing the Macro Settings

  1. Select [Macro Settings] from the navigation pane on the left-hand side of the screen.

image404.jpg

Figure 4: The Trust Center screen, accessing the Macro Settings

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

  2. Click [OK] again to exit the Access Options screen (not pictured).

  3. It is now acceptable to install the Order Manager on this workstation.

Setting the Default Database Type

  1. From the [File] Menu, select [Options]:

image405.jpg

Figure 5: The Trust Center screen, accessing the Macro Settings

The Access Options screen opens:

image407.jpg

Figure 6: The Trust Center screen, accessing the Macro Settings

  1. Select [General] from the navigation pane on the left-hand side of the screen.

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

  3. Click [OK] to exit the Access Options screen and save the new setting.

 

Related Topics

MS_Access_2013_.htm

Created: 3/22/11

Revised: 12/24/13

Modified: 1/17/12

Go to Top