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:
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:
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.
250616 ACC2000: How to Use Data Transformation Services (DTS) to Export Data from a Microsoft Access Database to a SQL Server Database
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
- 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.
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
Additional query words: pra overflow SQL8 SQL2000
Keywords: kbbug kberrmsg kbpending KB279454
