ACC97: "Overflow" Error Message When You Try to Upsize to SQL Server 2000

Article translations Article translations
Article ID: 279454 - View products that this article applies to.
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.

Expand all | Collapse all

On This Page

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.

More information

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 "Overflow," and that you are then returned to the wizard. The database is not upsized.

References

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

Properties

Article ID: 279454 - Last Review: October 26, 2013 - Revision: 4.0
Applies to
  • Microsoft Access 97 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kberrmsg kbpending KB279454

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com