Microsoft has released an update to Microsoft Access 2002. This update fixes an issue where descending indexes in Access 2002 that have been upsized to SQL Server may still be upsized as ascending indexes after you install Microsoft Office XP Service Pack 3. This update makes sure that Access 2002 wizard files are updated correctly.
This article describes the Microsoft Access 2002 Update, how
to obtain and install the update, and the issues that are fixed when you
install Access 2002 Update: KB 833857.
How to download and install the updateNote
Run the Upsizing Wizard before you install this update. If you do
not run the Upsizing Wizard before you install this update, and the wizard has
the Install on Demand
option turned on, the wizard may not be
updated correctly and the update may not work as expected.
and install the update, follow these steps:
following file is available for download from the Microsoft Download
the English version of Access 2002 Update: KB833857 package
Collapse this imageExpand this image
Release Date: March
For additional information about how to download Microsoft
Support files, click the following article number to view the article in the
Microsoft Knowledge Base:
119591 Microsoft scanned this file for viruses. Microsoft used the most
current virus-detection software that was available on the date that the file
was posted. The file is stored on security-enhanced servers that help to
prevent any unauthorized changes to the file.
How to Obtain Microsoft Support Files from Online Services
Note To obtain a localized version of Access 2002 Update: KB833857,
visit the following Microsoft Web site:
- Click Open to start the download and the
installation of Access 2002 Update: KB833857.
- If you are prompted to install the update, click
- Click Yes to accept the License
- Insert your Office XP CD-ROM if you are prompted to do so,
and then click OK.
- When you receive a message that indicates the installation
was successful, click OK.
- After you install the update, you cannot remove it. To
revert to an installation before the update was installed, you must remove
Office XP and then install it again from the original CD-ROM.
- If the Access 2002 Update: KB833857 is already installed on
your computer, you receive the following error message when you try to install
the Access 2002 Update: KB833857:
This update has already
been applied or is included in an update that has already been
The update contains the following files:
List of issues that are fixed by the update
The Access 2002 Update: KB833857 fixes the following issue:
The Upsizing Wizard creates descending indexes as ascending indexes
When you use the Upsizing Wizard in Microsoft Access 2002 to
upsize a database to SQL Server, you notice that descending indexes change to
ascending indexes in the resulting database.Notes
- This problem was first corrected in Microsoft
Office XP Service Pack 2.
For additional information, click the following article number to
view the article in the Microsoft Knowledge Base:
ACC2002: Issues fixed in Access 2002 by Office XP Service Pack 2
- This problem may occur even after you install Microsoft
Office XP Service Pack 2 (SP-2) or Microsoft Office XP Service Pack 3
For additional information, click the
following article number to view the article in the Microsoft Knowledge Base:
Descending Indexes in Access 2002 become ascending indexes when upsizing to SQL even after you install Office XP SP-2 or Office XP S328019
The Access 2002 Update:
KB833857 fixes the issue that is described in the following Microsoft Knowledge
ACC2002: Font list is displayed incorrectly in Label Wizard dialog box
The Access 2002 Update: KB833857 fixes the
following issues that were previously not documented in the Microsoft Knowledge
The linked table view can no longer be updated
If you update the link to a SQL Server View in Access 2002, the
linked table (view) can no longer be updated.
English language strings are taken from the form in the Microsoft Access database (MDE)
When you run the User Level Security Wizard, some English language
strings may be taken from the form in the Microsoft Access database (MDE). The
expected behavior is that the string is loaded from the Acwizrc.dll
Article ID: 833857 - Last Review: September 12, 2011 - Revision: 3.0
- Microsoft Access 2002 Standard Edition
|atdownload kbinfo kbupdate KB833857|