Microsoft KB Archive/274624

{|
 * width="100%"|

ACC2000: &quot;Overflow&quot; Error Message When You Try to Upsize to Microsoft SQL Server 2000

 * }

Q274624

-

The information in this article applies to:


 * Microsoft Access 2000

-

Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

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

Overflow.

RESOLUTION
Microsoft is currently addressing this issue, and will post more information here in the Microsoft Knowledge Base as it becomes available. In the meantime, please use one of the following workarounds:


 * Upsize your data to Microsoft SQL Server 7.0. You can then convert it to SQL Server 2000. To do this, either use the Copy Database Wizard from SQL Server 2000 or simply detach the database from SQL Server 7.0, and then attach it to SQL Server 2000. This will convert the database to the SQL Server 2000 format. Realize, however, that 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.
 * Use the Data Transformation Services Wizard (DTS) to move the data from Access to SQL Server 2000.

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Steps to Reproduce the 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 next page of the wizard, choose your SQL Server 2000 server. Enter an appropriate login and password, and then click Next.

Note that you receive the informational message &quot;Overflow,&quot; and that you are then returned to the wizard. The database is not upsized.

Additional query words: pra SQL8 SQL2000

Keywords : kberrmsg kbdta

Issue type : kbbug

Technology :