Microsoft KB Archive/904018

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

Article ID: 904018

Article Last Modified on 9/28/2007

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-





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



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.



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 Description of the Access 2002 post-Service Pack 3 hotfix package: June 2, 2004

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

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

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

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 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 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 You are unexpectedly prompted to restart the computer after you install an Office service pack or an Office update



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

How to determine whether the update is installed
The update contains files that have the versions that are listed in the following table.

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

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

Additional query words: access2002 access2k2 accessxp acc2002 acc2k2 accxp access office security patch performance reliability update download 2002 fix excel tables

Keywords: atdownload kbfix kbupdate KB904018

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.