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

Article translations Article translations
Article ID: 904018 - View products that this article applies to.
Expand all | Collapse all

On This Page

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:
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 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:
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 NameFile Version
Msaccess.exe10.0.6771.0
Msaexp30.dll10.0.6776.0
Mscdm.dll10.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.
Collapse this tableExpand this table
Name of .msp fileDescription
Msaccessop.mspApplies to the client version of this update.
Msaccessff.mspApplies 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

Properties

Article ID: 904018 - Last Review: September 28, 2007 - Revision: 1.4
APPLIES TO
  • Microsoft Access 2002 Standard Edition
Keywords: 
atdownload kbfix kbupdate KB904018

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com