ACC2000: Upsizing to SQL Server 7.0 Converts Text to nVarChar

Article translations Article translations
Article ID: 200405 - View products that this article applies to.
This article was previously published under Q200405
This article has been archived. It is offered "as is" and will no longer be updated.
Advanced: Requires expert coding, interoperability, and multiuser skills.

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

Expand all | Collapse all

On This Page

SYMPTOMS

If you upsize a table that has a field with a data type of Text, the Upsizing Wizard will map the type to the Microsoft SQL Server 7.0 nVarChar data type instead of the VarChar data type. This happens even though the Upsizing Wizard report indicates that the column was mapped to VarChar.

RESOLUTION

Manually change the data types on SQL Server to the data type that you want.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was fixed in Access 2002.

MORE INFORMATION

Steps to Reproduce Problem

  1. Open the sample database Northwind.mdb.
  2. Make a copy of the Categories table and name it tblTest.
  3. Open tblTest in Design view and take a look at the data types of the fields. Note that CategoryName has a data type of Text.
  4. Close the tblTest table.
  5. On the Tools menu, point to Database Tools, and then click Upsizing Wizard.
  6. Upsize the database to either a new or an existing SQL Server database.
  7. In the Upsizing Wizard, select the tblTest table to be upsized.
  8. When the wizard is finished, you see in the Upsizing Wizard report that the type column of the CategoryName field is VarChar.
  9. On a computer with the full version of SQL Server 7.0 installed, in SQL Server Enterprise Manager, open the database that you upsized to.
  10. Open the tblTest table in Design view.

    Note that the type column shows that CategoryName has a data type of nVarChar, not VarChar.

REFERENCES

For more information about the Upsizing Wizard, click Microsoft Access Help on the Help menu, type use the Upsizing Wizard in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Properties

Article ID: 200405 - Last Review: October 11, 2013 - Revision: 2.0
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbpending KB200405

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