Select the product you need help with

Description of the update for Access 2002: October 18, 2005

Article ID: 904018 - View products that this article applies to.

SUMMARY

Microsoft has released an update for Microsoft Access 2002. This article includes information about how to obtain the update and about how to obtain a list of issues that the update fixes.

Additionally, this article includes information about the issues that you may experience when you install the update and about how to determine whether the update is installed.

Back to the top | Give Feedback

INTRODUCTION

Microsoft has released an update for Microsoft Access 2002. This update removes the functionality in Access 2002 that lets users add new data to or edit existing data in a linked Microsoft Excel worksheet.

Back to the top | Give Feedback

MORE INFORMATION

Update details

Issues that were previously documented in the Microsoft Knowledge Base

The update for Access 2002 (KB904018) fixes the issues that are described in the following hotfix packages:

842780

(http://support.microsoft.com/kb/842780/ )

Description of the Access 2002 post-Service Pack 3 hotfix package: June 2, 2004

885235

(http://support.microsoft.com/kb/885235/ )

Description of the Access 2002 post-Service Pack 3 hotfix package: September 10, 2004

888994

(http://support.microsoft.com/kb/888994/ )

Description of the Access 2002 post-Service Pack 3 hotfix package: November 16, 2004

892095

(http://support.microsoft.com/kb/892095/ )

Description of the Access 2002 post-Service Pack 3 hotfix package: February 4, 2005

895469

(http://support.microsoft.com/kb/895469/ )

Description of the Access 2002 post-Service Pack 3 hotfix package: March 3, 2005

Issues that were not previously documented in the Microsoft Knowledge Base

The update for Access 2002 (KB904018) fixes the following issues that were not previously documented in the Microsoft Knowledge Base.

Access 2002 unexpectedly quits when you press ALT+F11 on a Microsoft Windows 98-based computer

You run Access 2002 on a Windows 98-based computer. If you open a database file (.mdb) and then press ALT+F11 to open the Visual Basic Editor (VBE), the VBE does not open. Additionally, Access 2002 unexpectedly quits.

You receive a Runtime Error 5 error message when you try to change the PaperBin property

When you try to set the PaperBin property to a value that is more than 256, you receive the following error message:

Run-time error '5': Invalid Procedure call or Argument.

Records are not filtered in a form when the FilterOn property is programmatically set to True

When you programmatically set the FilterOn property to True in an Access 2002 form, the form does not filter the records. Therefore, the form may continue to show all the records.

Known issues

Known issues after the installation of the update

When you try to update the data in tables that are linked to an Excel workbook in Access 2002, you cannot edit, add, or delete data in the tables.

For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base:
904953
(http://support.microsoft.com/kb/904953/ )
You cannot change, add, or delete data in tables that are linked to an Excel workbook in Office Access 2003 or in Access 2002
After you install a Microsoft Office update, you are unexpectedly prompted to restart the computer.

For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base:
905726
(http://support.microsoft.com/kb/905726/ )
You are unexpectedly prompted to restart the computer after you install an Office service pack or an Office update

Installation details

How to obtain and install the update

Both the client and administrative updates and the installation instructions and deployment strategies are found on the Microsoft Download Center. To download this update from the Microsoft Download Center, visit the following Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyId=7497D7F0-BEF5-4054-B854-B1240B5135F5

(http://www.microsoft.com/downloads/details.aspx?FamilyId=7497D7F0-BEF5-4054-B854-B1240B5135F5)

How to determine whether the update is installed

The update contains files that have the versions that are listed in the following table.

Collapse this tableExpand this table

File Name	File Version
Msaccess.exe	10.0.6771.0
Msaexp30.dll	10.0.6776.0
Mscdm.dll	10.0.0.6712

You do not have to install this update if you have a later version of the files that are listed in the table.

For more information about how to determine the version of Access 2002 that is installed on your computer, click the following article number to view the article in the Microsoft Knowledge Base:

291331

(http://support.microsoft.com/kb/291331/ )

How to check the version of Office XP

Information for administrators about .msp files

The administrative update consists of a full-file Microsoft Windows Installer patch file (.msp file) that is packaged in a self-extracting executable file. The .msp files in the following table are distributed in this update.

Collapse this tableExpand this table

Name of .msp file	Description
Msaccessop.msp	Applies to the client version of this update.
Msaccessff.msp	Applies to the full-file version of this update.

Features for reinstalling specific components for administrators

If you update your administrative installation point and recache and reinstall Access 2002 on client computers, you can run a command line that includes the REINSTALL=[list of features] property. The REINSTALL=[list of features] property specifies whether you want to reinstall specific components of Access 2002 from the administrative image. For the update for Access 2002 (KB904018), the value for [list of features] is as follows:

For Access 2002

ACCESSFiles,OfficeWebComponents,ACCESSNonBootFiles,OfficeWebComponents10

For Access 2002 Runtime

ACCESSFiles,OfficeWebComponents,ACCESSNonBootFiles

Optionally, you can substitute the parameter REINSTALL=ALL to reinstall all Microsoft Office components on the client computer.

The Office Admin Update Center for Office IT Professionals contains the latest administrative updates and strategic deployment resources for all versions of Office. For more information about the Office Admin Update Center, visit the following Microsoft Web site:

http://technet.microsoft.com/office/bb267346.aspx

(http://technet.microsoft.com/office/bb267346.aspx)

Back to the top | Give Feedback