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.
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 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:
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 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
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:
How to determine whether the update is installed
The update contains files that have the versions that are listed in the following 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 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.
| 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:
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
