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 SP3

Article ID: 328019

Article Last Modified on 9/9/2004

APPLIES TO

Microsoft Access 2002 Standard Edition

This article was previously published under Q328019

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

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:

Quit any programs that are running.
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.
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.
Click OK when you receive the message that states that the Setup program completed successfully.
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

Additional query words: OFFXP pra Acc2002

Keywords: kbtshoot kbbug kbfix KB328019

Microsoft KB Archive/328019

Contents