Descending indexes in Access 2002 become ascending indexes when upsizing to SQL even after you install Office XP SP-2 or Office XP SP3

Article translations Article translations
Article ID: 328019 - View products that this article applies to.
This article was previously published under Q328019
This article has been archived. It is offered "as is" and will no longer be updated.
Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows Registry
Expand all | Collapse all

On This Page

Symptoms

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.

Note This issue occurs even after you install Microsoft Office XP Service Pack 2 (SP-2) or Microsoft Office XP Service Pack 3 (SP3). The fix for this issue is documented as being fixed in Office XP SP-2. For additional information about the issue that is described in the "Symptoms" section of this article, click the following article number to view the article in the Microsoft Knowledge Base:
325670 List of issues fixed in Access 2002 by Office XP Service Pack 2

Cause

This issue may occur when you run the Upsizing Wizard, and then later you install Office XP SP-2 or Office XP SP3. As part of the Office XP SP-2 or Office XP SP3 update process, versioned files that are not user-modified are updated. If you run the Upsizing Wizard, the versioned files that are associated with the wizard are modified and Office XP SP-2 and SP3 treat them as unversioned user-modified files and may not be able to update them correctly.

Resolution

To resolve this issue, download and install the Access 2002 Update: KB833857. For additional information about the Access 2002 Update: KB833857, click the following article number to view the article in the Microsoft Knowledge Base:
833857 Description of Microsoft Access 2002 Update: March 23, 2004

Administrative information

If you are an administrator, there are additional methods that you can use to resolve this issue. Database administrators may deploy Office XP Service Pack 2 or Office XP Service Pack 3 by using the method that is described in the service pack literature on the Office Resource Kit (ORK), and then follow these steps for user systems that run Access 2002.

Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk. Locate your GUID number, and then run Msiexec.exe. To do so, follow these steps:
  1. Quit any programs that are running.
  2. Locate your alphanumeric GUID number that is associated with the Microsoft Office product that you are trying to update. To do this, follow these steps:
    1. Click Start, and then click Run.
    2. In the Open box, type Regedit, and then click OK.
    3. Locate, and then expand the following key in the registry.

      HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Uninstall
    4. Select the first 32-character {GUID} folder that is listed, and then check the DisplayName value (in the right pane) until you find a value that matches the installation of Office that you are updating. If the DisplayName value does not match your installation of Office, continue to the next {GUID} that is listed under the Uninstall folder.
    5. After you find the correct {GUID} Key, you can copy the Key Name if you right-click the Key, and then click Copy Key Name.
    6. Start Notepad or some other text editor, and then paste the Key Name into the document.
    7. Select, and then copy only the GUID from the Key Name.
  3. Click Start, and then click Run.

    Type the following command in the Open box, and then click OK:
    msiexec /i guid REINSTALL=AccessFiles,AccessWizards REINSTALLMODE=dmu
    Where guid is the 32-character alphanumeric GUID number that is associated with the product.
  4. Click OK when you receive the message that states that the Setup program completed successfully.
  5. Click Yes if you are prompted to restart the computer.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section of this article.

More information

After Office XP SP-2 is installed and the Access 2002 wizard files have been updated by using the Msiexec.exe utility, the wizard files must have the following file attributes or later:
   Date         Time               Size    File name
   ----------------------------------------------------
   05-Dec-2001  04:46           1,662,976  Acwzlib.mde
   05-Dec-2001  04:46           5,345,280  Acwzmain.mde
   25-Apr-2002  02:03           8,019,968  Acwztool.mde
				

References

For additional information about GUID numbers and the Msiexec.exe utility, click the following article number to view the article in the Microsoft Knowledge Base:
302663 OFFXP: Numbering Scheme for Product Code GUIDs
For additional information about Office XP Service Pack 2 in the service pack literature on the Office Resource Kit (ORK), visit the following Microsoft Web site:
http://www.microsoft.com/office/ork/xp/journ/oxpsp2a.htm
For additional information about Office XP Service Pack 3 in the service pack literature on the Office Resource Kit (ORK), visit the following Microsoft Web site:
http://www.microsoft.com/office/ork/2003/admin/xp/oxpsp3a.htm
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 328019 - Last Review: October 24, 2013 - Revision: 1.0
Applies to
  • Microsoft Access 2002 Standard Edition
Keywords: 
kbnosurvey kbarchive kbtshoot kbbug kbfix KB328019

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com