Microsoft KB Archive/287484

= How to download and install an administrative update available for the Access 2000 and SQL Server 2000 Readiness Update =

Article ID: 287484

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition
 * Microsoft Office 2000 Premium Edition
 * Microsoft Office 2000 Professional Edition
 * Microsoft Office 2000 Standard Edition
 * Microsoft Office 2000 Small Business Edition
 * Microsoft Office 2000 Developer Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft FrontPage 2000 Standard Edition
 * Microsoft Outlook 2000 Standard Edition
 * Microsoft PowerPoint 2000 Standard Edition
 * Microsoft Word 2000 Standard Edition

-



This article was previously published under Q287484



SUMMARY
To help you deploy the Access 2000 and SQL Server 2000 Readiness Update within your organization, Microsoft is providing an update for Office 2000 administrative installations. This update is contained in a self-extracting file that is available in the Microsoft Office Resource Kit Toolbox.

The &quot;More Information&quot; section of this article describes how to download and install this update on your administrative installation.



Issue Fixed in Microsoft Office 2000 Service Pack 3 (SP-3)
This issue was fixed in Office 2000 SP-3. Office 2000 SP-3 was released on November 13, 2002. For additional information about Office 2000 SP-3 and how to install it, click the following article number to view the article in the Microsoft Knowledge Base:

326585 OFF2000: Overview of Office 2000 Service Pack 3

Use the Readiness Update Without Upgrading to Office 2000 SP-3
You can apply the Access 2000 and SQL Server 2000 Readiness Update to your administrative installation without upgrading to Office 2000 SP-3. However, you must first apply the SR-1/SR-1a update to your administrative installation. Depending on whether you already installed SR-1/SR-1a on your network clients, please follow the steps in the appropriate section of this article.

For additional information about the difference between the Office 2000 SR-1 Update and the Office 2000 SR-1a Update, click the article number below to view the article in the Microsoft Knowledge Base:

261933 OFF2000: What Is the SR-1a Update?

IMPORTANT: After installing this update, you must use Mixed Mode Authentication (Windows Authentication and SQL Server Authentication) to upsize your database by using a SQL Server logon. Windows Authentication mode is not supported. If Windows Authentication mode is set when you upsize, your tables or queries may be skipped.

NOTE: If you install SQL Server with Windows Authentication Mode set, and later you change the Security Authentication to Mixed Mode Authentication, the built-in system administrator (SA) logon password may be blank. After enabling SQL Server security, you should immediately create a password for the &quot;SA&quot; logon to help prevent unauthorized access to your SQL Server. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

274773 FIX: If You Change Windows Security to Windows/SQL Security the SA Password is Blank

After SQL Server Authentication is enabled, you can use the built-in &quot;SA&quot; account or create a new SQL Server account for upsizing. If you are using a new account, be sure to set the &quot;Server Role&quot; to &quot;Database Creators&quot;. For more information, see SQL Server Books Online.

Update an Administrative Installation with the Access 2000 and SQL Server 2000 Readiness Update
 Browse to following Microsoft Web site:

http://www.microsoft.com/office/ork/2000/journ/Accsql.htm

 Click the download for ACCSQL_A.EXE. In the File Download dialog box, click Save this program to disk, and then click OK. Save the file to your desktop. In Windows Explorer, double-click the ACCSQL_A.EXE file. Click Yes to accept the End User License Agreement. Type c:\accsql in the Please type the location where you want to place the extracted files box, and then click OK. Click Yes when you are prompted to create the folder.

NOTE: You must run the next command from a computer on which the Windows Installer is already installed.</li> Click Start, and then click Run. Type the following command in the Open box

msiexec /a \Data1.msi /p c:\accsql\ACWZ_Admin.msp SHORTFILENAMES=1

where  is the path to your administrative installation point.</li> Click Next in the Microsoft Office 2000 Administrative Mode dialog box.

NOTE: You do not have to type your CD Key or company name in the Microsoft Office 2000 Administrative Mode dialog box.</li> Click I accept the terms in the License Agreement, and then click Next.</li> Click Install Now, and then click OK when the installation is completed.</li> At this point, your administrative installation point is updated with the first of two .msp files. Repeat steps 8 through 11 for the .msp file Mdt2_admin.msp. When you apply Mdt2_admin.msp, make sure to change the .msp file name used in the command line in step 8.</li></ol>

Update Network Clients with the Access 2000 and SQL Server 2000 Readiness Update
You must follow these steps at each network client: <ol> Rename the following files by changing the extension from .mde to .old:

Acwzlib.mde

Acwzmain.mde

Acwztool.mde

For the English version of Office, these files are located by default in the C:\Program Files\Microsoft Office\Office\1033 folder.</li> Click Start, and then click Run. Type the following command in the Open box

msiexec /i \Data1.msi REINSTALL=ALL REINSTALLMODE=vomus UPGRADEWITHRECACHE=TRUE /q

where  is the path to your administrative installation point.

The &quot;UPGRADEWITHRECACHE=TRUE&quot; property is required to correctly update the Microsoft SQL Server support files. This property causes the End User License Agreement acceptance dialog box to appear. The &quot;/q&quot; switch suppresses the End User License Agreement dialog box, so that administrators and end users are not prompted by this dialog box.</li> Click OK when the update is finished.</li> Click Yes if you are prompted to restart your computer.</li></ol>

Your network client is now configured with the Access 2000 and SQL Server 2000 Readiness Update.

Update the Administrative Installation to SR-1/SR-1a First
If you already updated your administrative installation with the SR-1/SR-1a Administrative update, skip this section, and follow the steps in the &quot;Update an Administrative Installation with the Access 2000 and SQL Server 2000 Readiness Update&quot; section earlier in this article.

To update your administrative installation with the SR-1/SR-1a update, click the article number below to view the article in the Microsoft Knowledge Base:

257983 OFF2000: How to Obtain and Apply the SR-1/SR-1a Update to Administrative Installations

NOTE: After you update your administrative installation with the SR-1/SR-1a update, you do not yet need to update your network clients to SR-1/SR-1a. When you run the command line in the &quot;Update Network Clients with the SR-1/SR-1a and Web Client Security Update&quot; section later in this article, your client is updated with both the SR-1/SR-1a and Access 2000 and SQL Server 2000 Readiness Update.

After you perform the steps in article Q257983 to update your administrative installation with the SR-1/SR-1a update, continue with the following steps.

Update an Administrative Installation with the Access 2000 and SQL Server 2000 Readiness Update
<ol> Browse to following Microsoft Web site:

http://www.microsoft.com/office/ork/2000/journ/Accsql.htm

</li> Click the download link for ACCSQL_A.EXE.</li> In the File Download dialog box, click Save this program to disk, and then click OK.</li> Save the file to your desktop.</li> In Windows Explorer, double-click the ACCSQL_A.EXE file.</li> Click Yes to accept the End User License Agreement.</li> <li>Type c:\accsql in the Please type the location where you want to place the extracted files box, and then click OK. Click Yes when you are prompted to create the folder.</li> <li>Click Start, and then click Run. Type the following command in the Open box

msiexec /a \Data1.msi /p c:\accsql\ACWZ_Admin.msp SHORTFILENAMES=1

where  is the path to your administrative installation point.</li> <li>Click Next in the Microsoft Office 2000 Administrative Mode dialog box.

NOTE: You do not have to type your CD Key or company name in the Microsoft Office 2000 Administrative Mode dialog box.</li> <li>Click I accept the terms in the License Agreement, and then click Next.</li> <li>Click Install Now, and then click OK when the installation is completed.</li> <li>At this point, your administrative installation point is updated with the first of two .msp files. Repeat steps 8 through 11 for the .msp file Mdt2_admin.msp. When you apply Mdt2_admin.msp, make sure to change the .msp file name used in the command line in step 8.</li></ol>

Update Network Clients with the SR-1/SR-1a and Web Client Security Update
You must follow these steps at each network client: <ol> <li>Click Start, and then click Run. Type a command line similar to the following in the Open box

\Setup /qb

where  is the path to your administrative installation point.</li> <li>Click Yes if you are prompted to restart your computer.</li> <li>Click Yes if you are prompted again to restart your computer.</li></ol>

Your network client is now configured with the SR-1/SR-1a update and the Access 2000 and SQL Server 2000 Readiness Update.

NOTE: If you already updated your administrative installation with both SR-1/SR-1a and the Access 2000 and SQL Server 2000 Readiness Update, you can run Setup from the administrative installation on a network client that does not currently have Office installed. When Setup is finished, the network client is configured with SR-1/SR-1a and the Access 2000 and SQL Server 2000 Readiness Update. You do not have to perform any repair or reinstall procedures on this network client.

Confirm That the Access 2000 and SQL Server 2000 Readiness Update Is Successfully Installed
The following table lists the files that are updated by the Access 2000 and SQL Server 2000 Readiness Update. In Windows Explorer, you can right-click a file from the table and click the Version tab to confirm the version information. <pre class="fixed_text"> File Name     File Version   Size (Bytes) - Acwzlib.mde    n/a            1,241,088 Acwzmain.mde  n/a            3,854,336 Acwztool.mde  n/a            5,111,808 Mdt2db.dll    2.0.0.8958       679,936 Mdt2dbns.dll  2.0.0.8958       372,736 Mdt2dd.dll    2.0.0.8958       471,040 Mdt2df.dll    2.0.0.8958       618,496 Mdt2dfx.dll   2.0.0.8958        24,576 Mdt2fref.dll  2.0.0.8958        45,056 Mdt2fw.dll    2.0.0.8958       536,576 Mdt2fwui.dll  2.0.0.8958        66,832 Mdt2g.dll     2.0.0.8958       602,112 Mdt2gddo.dll  2.0.0.8958        61,440 Mdt2gddr.dll  2.0.0.8958       126,976 Mdt2qd.dll    2.0.0.8958     1,327,104 Msowci.dll    9.0.0.4625        90,112 NOTE: The .mde files have no version information.

<div class="references_section">