This article was previously published under Q288300
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
After you install the Access 2000 and SQL Server 2000 Readiness Update and try to run the Upsizing Wizard, the Linked Table Manager, or the Add-in Manager, you receive the following error message:
Microsoft Access can't find the wizard, or there is a syntax error in the Declarations section of a Visual Basic module.
You may experience this problem if you run the Upsizing Wizard to Microsoft SQL Server 7.0 before you install the Access 2000 and SQL Server 2000 Readiness Update.
To correct this problem, remove the Acwztool.mde file, and then run Repair. This not only replaces the file, but also replaces it with the updated version of the wizard. At this point, the wizard runs and can upsize to Microsoft SQL Server 2000. To run Repair, follow these steps:
Browse to the folder that contains Acwztool.mde, and then delete that file. By default, Acwztool.mde is located in the C:\Program Files\Microsoft Office\Office\1033 folder for English versions of Microsoft Office 2000.
Quit all programs.
Click Start, point to Settings, and then click Control Panel.
In Control Panel, double-click Add/Remove Programs.
Double-click the Office 2000 entry listed in the Add/Remove Programs dialog box.
Click Repair Office.
Click either Reinstall Office or Repair errors in my Office installation, and then click Finish.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
For additional information about running the Office 2000 Repair or Reinstall, click the article numbers below to view the articles in the Microsoft Knowledge Base:
264625 OFF2000: How to Install or Repair Microsoft Office 2000
230672 OFF2000: Differences Between Repair and Reinstall