List of issues fixed in Access 2002 by Office XP Service Pack 2

Microsoft has released Microsoft Office XP Service Pack 2 (SP-2). This article describes the issues that are fixed for Microsoft Access 2002.

For additional information about how to download and how to install Office XP Service Pack 2, click the article number below to view the article in the Microsoft Knowledge Base:

Access 2002 Issues That Are Fixed by Office XP Service Pack 2

For additional information about how the update fixes the issues that are described in the articles, click the following article numbers to view the articles in the Microsoft Knowledge Base: Additionally, this article summarizes other issues that are fixed.

Additional Issues That Are Fixed by Office XP SP-2

Additionally, the following issues are also fixed.

Horizontal Scroll Bar Is Not Displayed on a Subform

When a subform control is less than 4 inches wide and the subform control uses the record navigation buttons and the horizontal scroll bar, the horizontal scroll bar does not appear. This occurs even when you must have the horizontal scroll bar.

Using CTRL+APOSTROPHE and Appending Text Causes Access to Quit

The Japanese version of Access unexpectedly quits after you insert the value from the same field in the previous record by using CTRL+APOSTROPHE ('), and then append additional text to that field.

Records Not Updateable After Using Linked Table Manager

You cannot update records in a linked table that is linked to a view after you run the Linked Table Manager to refresh the links.

Cannot Repair a Password Protected Database

When you try to open a database that has a password and that must be repaired, you receive the message although you entered the correct password. Therefore, the database cannot be opened and cannot be repaired.

No Confirmation Deleting a Record

When you delete a record from a form, you do not receive a message that prompts you to confirm if you want to delete the record. This occurs when the Record Changes check box is selected and both the Modal and the Pop-up form properties are set to Yes.

Sort Order of Indexes Change After Upsizing Database

After you use the Upsizing Wizard to upsize a database, any indexes that are set to descending order are changed to ascending order in the resulting database.

NOTE: To prevent this problem, you must install both the Office XP SP-2 and Microsoft Data Access Components (MDAC) 2.6 or later. To install the latest version of MDAC, visit the following Microsoft Web site:


You can also use the Component Checker from this site to determine the current version of MDAC installed on your computer.

Spanish Access Does Not Recognize the Word Formularios

The Spanish version of Access cannot correctly interpret the word Formularios, which means Forms. This may unexpectedly cause a prompt for a parameter value.

Action Query Commits Changes to Data When Cancelled

When you run an action query that has been converted from a select query and you respond with No to the prompt to commit the changes, the changes are still committed.

For additional information about known issues with Office XP Service Pack 2, click the article number below to view the article in the Microsoft Knowledge Base: