Microsoft Access 2010 crashes or stops responding when attempting to copy a record in Access Datasheet View

When attempting to copy a record in Microsoft Access 2010 Datasheet View, Access stops responding

The Microsoft Office Professional 2010 suite was installed with Access set to "Not Available" and a stand-alone version of Microsoft Access 2010 was installed on the same machine.

Remove the stand-alone installation of Microsoft Access 2010.

Add Access from the Office Professional 2010 installation using one of the two following methods.

Method 1

1. Close any open Office 2010 programs.
2. Open the Control Panel
3. Click Add/Remove programs or Programs and Features
4. Select the Office 2010 installation
5. Select Change and Add or Remove Features
6. Click Continue.
7. Select the dropdown to the left of Microsoft Access and select either "Run from my computer" or "Run all from my computer". Note that "Run from my computer" allows you to select or deselect features to install with Microsoft Access.
8. Click Continue. Microsoft Office 2010 will reconfigure.

Method 2

For administrative installations on multiple machines, create an .msp to add Microsoft Access to the existing Office 2010 installation. See More Information for resources on creating an msp.

This article applies to installations of Microsoft Access 2010 stand alone on machines that have the following suites:

• Microsoft Office Professional 2010
• Microsoft Office Professional Acadmeic 2010
• Microsoft Office Professional Plus 2010 

With administrative installs, you can create an msp to update the existing install so that any product you had originally set to "Not Available" will be installed. Refer to the following articles:

• How to install Office 2010 applications for a subset of users in your organization   
• Change users� configurations after installing the 2010 Office system

 Additional known problems caused by installing Access 2010 stand-alone with Office 2010 Professional Plus

 
• When attempting to copy a record in Microsoft Access 2010 Datasheet View, Access stops responding
• Error attempting to import a file in Microsoft Access 2010: "Microsoft Access can't start this wizard. This feature is not available..."

In these cases, uninstalling Microsoft Access stand-alone and setting Access to "Run from my computer" in Office 2010 Professional Plus resolves the problems.
 

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.