Description of Microsoft Access 2002 Update: March 23, 2004

View products that this article applies to.

SUMMARY

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.

Back to the top

INTRODUCTION

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.

Back to the top

MORE INFORMATION

How to download and install the update

Note 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.

To download and install the update, follow these steps:

The following file is available for download from the Microsoft Download Center:

Collapse this imageExpand this image
Download the English version of Access 2002 Update: KB833857 package now. (http://download.microsoft.com/download/7/9/2/792198a5-8d5b-4b2e-882d-8efe3d8e9fcf/officexp-kb833857-client-enu.exe)

Release Date: March 23, 2004

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 (http://support.microsoft.com/kb/119591/ ) How to Obtain Microsoft Support Files from Online Services
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.

Note To obtain a localized version of Access 2002 Update: KB833857, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=66C8831F-B463-45F8-9651-C65A310A5F6B (http://www.microsoft.com/downloads/details.aspx?FamilyId=66C8831F-B463-45F8-9651-C65A310A5F6B)
Click Open to start the download and the installation of Access 2002 Update: KB833857.
If you are prompted to install the update, click Yes.
Click Yes to accept the License Agreement.
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.

Notes

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 applied.

Back to the top

Updated files

The update contains the following files:

   File name     
   ----------- 
   Acwzlib.mde    
   Acwzmain.mde   
   Acwztool.mde

Back to the top

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:
325670 (http://support.microsoft.com/kb/325670/ ) 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 (SP3).

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
328019 (http://support.microsoft.com/kb/328019/ ) 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 Base article:

314413 (http://support.microsoft.com/kb/314413/ ) 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 Base.

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 file.

Back to the top