Description of Microsoft Access 2002 Update: March 23, 2004 (833857)

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:

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

2. Click Open to start the download and the installation of Access 2002 Update: KB833857.
3. If you are prompted to install the update, click Yes.
4. Click Yes to accept the License Agreement.
5. Insert your Office XP CD-ROM if you are prompted to do so, and then click OK.
6. 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.

Updated files

The update contains the following files:

   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

• 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

• 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

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



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.