Microsoft KB Archive/279454

= ACC97: &quot;Overflow&quot; Error Message When You Try to Upsize to SQL Server 2000 =

Article ID: 279454

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q279454



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



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

Overflow



RESOLUTION
To work around this behavior, use one of the following methods:  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 converts 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.For additional information about this issue, click the article number below to view the article in the Microsoft Knowledge Base:

261334 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 additional information about this process, click the article number below to view the article in the Microsoft Knowledge Base:

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

NOTE: Using DTS to import Access tables creates the Unicode character fields nChar, nVarChar, and nText by default. These fields may cause problems when linking from Access 97, which does not support Unicode. Microsoft recommends that these fields be converted to Char, VarChar, and Text when linking from Access 97.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are 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 Add-ins, and then click Upsize to SQL-Server.
 * 3) On the first page of the wizard, accept the default choice, and then click Next.
 * 4) Select the DSN for the SQL Server 2000, and then click OK.

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

