Moderate: Requires basic macro, coding, and interoperability
skills.
This article applies to a Microsoft Access database (.mdb) and to a
Microsoft Access project (.adp).
SUMMARY
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:
325671 OFFXP: Overview of the Office XP Service Pack 2 (SP-2)
MORE INFORMATION
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:
313915
ACC2002: Database Window Is Displayed When You Click the Application Icon Even Though You Turned Off the "Display Database Window" Startup Option
322860 ACC2002: Database Password Prompt Appears After You Open a Database Using a Hyperlink or Visual Basic for Applications (VBA) Code
320713 ACC2002: A Report That Should Open to Print Preview View or to Print Switches to Design View Unexpectedly
311888 ACC2000: Horizontal Scroll Bar Is Not Displayed on a Subform
314413 ACC2002: Font List Is Displayed Incorrectly in Label Wizard Dialog Box
Additionally, this article summarizes other issues
that are fixed.
311219 BUG: Office XP Version of Mscal.ocx Breaks Binary Compatibility For Early Bound Clients
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
Not a valid
password
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.