Microsoft Knowledge Base Wiki

When you attempt to upsize a Microsoft Access 2000 database
to Microsoft SQL Server 2000, you may receive the following error message:

You may also receive the
same error message when you try to create an Access project that connects
to an instance of Microsoft SQL Server 2000 Desktop Engine (MSDE
2000).

Office 2000 Service Pack 3

To correct this problem, obtain the latest service pack for
Microsoft Office 2000.
For additional information, click the
following article number to view the article in the Microsoft Knowledge Base:

IMPORTANT: Before you install Microsoft Office 2000 Service Pack 3 (SP-3),
you must have Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a) installed
first.
For additional information about how
to obtain Office 2000 Service Release 1/1a (SR-1/SR-1a), click the following
article number to view the article in the Microsoft Knowledge Base:

Access 2000 and SQL Server 2000 Readiness Update

Microsoft has created the “Access 2000 and SQL Server 2000
Readiness Update” to correct this issue. Follow the steps below to obtain and
install this update:

1. Make sure you have Office (or Access) 2000 SR-1. You can
   obtain the Office 2000 SR-1/SR-1a update the from the following Microsoft Web
   site:
2. Rename the following files by changing the extension from
   .mde to .old:

   Acwzlib.mde
   Acwzmain.mde
   Acwztool.mde

   For the English version of Office, by default, these files are
   located in the C:Program FilesMicrosoft OfficeOffice1033
   folder.

3. Download the “Access 2000 and SQL Server 2000 Readiness
   Update” from the following Microsoft web site: Make a note of the folder to which you download this
   update.
4. Double-click the Accsql_a.exe file, which you downloaded in
   step 3, to install the “Access 2000 and SQL Server 2000 Readiness
   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 login. 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 change the Security Authentication to Mixed Mode Authentication, the
built-in system administrator (SA) login’s password may be blank. After
enabling SQL Server security you should immediately create a password for the
‘SA’ login to help prevent unauthorized access to your SQL Server.
For
additional information, click the article number below to view the article in
the Microsoft Knowledge Base:

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

Work around the Error Without the Readiness Update

You can work around the problem by using one of the following
methods instead of installing the “Access 2000 and SQL Server 2000 Readiness
Update”:

• Upsize your data to SQL Server 7.0 or Microsoft Data Engine
  (MSDE) first. You can then convert the SQL Server 7.0 or MSDE database to SQL
  Server 2000. You can accomplish the conversion in several ways:
  • Use the Data Transformation Services Wizard (DTS) to
    move the data from SQL Server 7.0 or MSDE to SQL Server 2000.
  • Use the “Copy Database Wizard” in SQL Server 2000 to
    move the data.
  • Detach the database from SQL Server 7.0 or MSDE, and
    then attach it to SQL Server 2000.

    CAUTION: Once you have converted the database to the SQL Server 2000
    format, you will not be able to reattach the database to SQL Server 7.0.

    For more information about upgrading to SQL Server 2000, please see
    the following article in the Microsoft Knowledge Base:For additional information about upgrading to SQL Server
    2000, click the article number below to view the article in the Microsoft
    Knowledge Base:

    261334

    (http://support.microsoft.com/kb/261334/EN-US/
    )

    INF: Frequently Asked Questions – SQL Server 2000 – Upgrade

• Use the Data Transformation Services Wizard (DTS) to move
  the data from Access to SQL Server 2000. For more information about this
  process, please see the following article in the Microsoft Knowledge Base
  article:
  For additional information about this
  process, click the article number below to view the article in the Microsoft
  Knowledge Base:
  250616

  (http://support.microsoft.com/kb/250616/EN-US/
  )

  ACC2000: How to Use Data Transformation Services (DTS) to Export Data from a Microsoft Access Database to a SQL Server Database

Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
at the beginning of this article.

If you previously ran the Upsizing wizard to upsize an
Access 2000 database to SQL Server 7.0, you may encounter another error after
applying this update.
For additional information about this error
message, click the article number below to view the article in the Microsoft
Knowledge Base:

Steps to Reproduce Behavior

1. Open the sample database Northwind.mdb.
2. On the Tools menu, point to Database Utilities, and then click Upsizing Wizard.
3. On the first page of the wizard, accept the default choice,
   and then click Next.
4. On the second page of the wizard, select your SQL Server
   2000 server, type an appropriate logon name and password, and then click Next.

Note that you receive the “Overflow” error message, and that
you are then returned to the wizard. The database is not upsized.

For information about applying the Access 2000 and SQL
Server 2000 Readiness Update to an administrative installation of Office, click
the article number below to view the article in the Microsoft Knowledge Base:
For
additional information about how you can apply the Access 2000 and SQL Server
2000 Readiness Update to an administrative installation of Office, click the
article number below to view the article in the Microsoft Knowledge Base:

Article ID: 272384 – Last Review: July 30, 2012 – Revision: 9.0