Go to Bottom

MS Access 2010 Notes

In 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 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:

• If the AutoNumber field is the primary key in the table and the primary key sort is descending and more than 1000 records are in the table.                                               

• If the AutoNumber field is included in a multi-field primary key and any of the fields in the primary key are sorted in descending order and more than 1000 records are in the table.

• If the AutoNumber field is NOT part of the primary key regardless of whether contained in another index and the table contains more than 1000 records

• If the AutoNumber field is part of a multi-field primary key sorted in ascending order and there are more than 2000 records in the table

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

• The Order Manager requires the use of the 32-bit version of Microsoft Access (or Office) 2010, even for users that have purchased hardware 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 2010 has been pre-installed (bundled with the purchase of the PC Personal Computer, or workstation), the user must un-install that software and re-install the 32-bit version before attempting to use the Order Manager. Contact the hardware/software provider about its availability.  

• As of March 2010, Microsoft was advising customers to use the 32-bit edition of Office 2010, rather than the 64-bit edition. http://www.pcpro.co.uk/news/enterprise/356173/microsoft-warns-users-off-64-bit-office-2010

• 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 synonymous with the Microsoft Access Form Object or user interface., the key combination of "ALT" plus the letter "M" will cause the Line Items tab to be opened.

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:

• Macro Security

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

Setting Macro Security

1. From the [File] Menu, select to mouse "left-click" on an object, usually a row in a table, in the context of Order Manager documentation [Options]:

Figure 1: c

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

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

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

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

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

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

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

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

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

Setting the Default Database Type

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

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

The Access Options screen opens:

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

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

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

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

MS_Access_2013_.htm

Created: 3/22/11

Revised: 12/24/13

Modified: 1/17/12

Go to Top