Article ID: 904018 - View products that this article applies to.
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.
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 BaseThe update for Access 2002 (KB904018) fixes the issues that are described in the following hotfix packages:
(http://support.microsoft.com/kb/842780/ )Description of the Access 2002 post-Service Pack 3 hotfix package: June 2, 2004
(http://support.microsoft.com/kb/885235/ )Description of the Access 2002 post-Service Pack 3 hotfix package: September 10, 2004
(http://support.microsoft.com/kb/888994/ )Description of the Access 2002 post-Service Pack 3 hotfix package: November 16, 2004
(http://support.microsoft.com/kb/892095/ )Description of the Access 2002 post-Service Pack 3 hotfix package: February 4, 2005
(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 BaseThe 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
How to obtain and install the updateBoth 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:
How to determine whether the update is installedThe 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.
Collapse this tableExpand this 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:
(http://support.microsoft.com/kb/291331/ )How to check the version of Office XP
Information for administrators about .msp filesThe 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
Features for reinstalling specific components for administratorsIf 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,OfficeWebComponents10For Access 2002 Runtime
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:
Contact us for more help
Connect with Answer Desk for expert help.