This article was previously published under Q279454
This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.
When you try to upsize a Microsoft Access database to SQL Server 2000, you may receive the following error message:
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:
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.
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
Open the sample database Northwind.mdb.
On the Tools menu, point to Add-ins, and then click Upsize to SQL-Server.
On the first page of the wizard, accept the default choice, and then click Next.
Select the DSN for the SQL Server 2000, and then click OK.
Note that you receive the informational message "Overflow," and that you are then returned to the wizard. The database is not upsized.
For additional information about utilities that you can use to upsize an Access 97 database to Microsoft SQL Server, click the article number below to view the article in the Microsoft Knowledge Base:
176614 ACC97: Microsoft Access 97 Upsizing Tools Available