Microsoft KB Archive/833857

= Description of Microsoft Access 2002 Update: March 23, 2004 =

Article ID: 833857

Article Last Modified on 8/11/2004

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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



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.



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:

Download the English version of Access 2002 Update: KB833857 package now.

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

 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.</ol>

Notes <ul> 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.</li> 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.

</li></ul>

Updated files
The update contains the following files: <pre class="fixed_text">  File name ---   Acwzlib.mde Acwzmain.mde Acwztool.mde

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 <ul> 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 ACC2002: Issues fixed in Access 2002 by Office XP Service Pack 2

</li> 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 Descending Indexes in Access 2002 become ascending indexes when upsizing to SQL even after you install Office XP SP-2 or Office XP S328019

</li></ul>

The Access 2002 Update: KB833857 fixes the issue that is described in the following Microsoft Knowledge Base article:

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.

Keywords: kbinfo kbupdate atdownload KB833857

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.