You are currently offline, waiting for your internet to reconnect

Error message when you try to upsize your Access database by using the Upsizing Wizard: "The Upsizing Wizard only works with Microsoft SQL Server (Versions 6.50 SP5 or higher). Please log in to a SQL Server data source."

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.


This article applies to a Microsoft Access database (.mdb) file or to a Microsoft Access database (.accdb) file.Advanced: Requires expert coding, interoperability, and multiuser skills.
SYMPTOMS
When you use the Upsizing Wizard to migrate the database objects from a Microsoft Access database (.mdb or .accdb) to an existing Microsoft SQL Server database, and you use the System Data Source Name (System DSN) or the User Data Source Name (User DSN) to connect to the instance of SQL Server, you may receive the following error message:
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.
Additionally, when you click OK on the error message, you receive the following error message:
The Upsizing Wizard only works with Microsoft SQL Server (Versions 6.50 SP5 or higher). Please log in to a SQL Server data source.
NoteThis problem occurs when your Access database and the instance of SQL Server do not exist on the same computer.
WORKAROUND
To work around this problem, use a File DSN to connect to your instance of SQL Server when you upsize your Access database. To do this, follow these steps:
  1. Start Access.
  2. Open the problem database.
  3. On the Tools menu, point to Database Utilities, and then click Upsizing Wizard.

    Note In Access 2007, click SQL Server in the Move Data group on the Database Tools tab.
  4. In the Upsizing Wizard dialog box, click theUse existing database option, and then click Next.
  5. In the Select Data Source dialog box, select the appropriate DSN to connect to your instance of SQL Server on the File Data Source tab.
  6. Click OK.
  7. Enter the appropriate authentication information to connect to your instance of SQL Server if the SQL Server Login dialog box appears.
  8. Follow the instructions in the Upsizing Wizard.

    Notice that the Access database is successfully upsized without any errors.
MORE INFORMATION

Steps to reproduce the problem

  1. Start Access.
  2. Open the Northwind sample database.
  3. On the Tools menu, point to Database Utilities, and then click Upsizing Wizard.

    Note In Access 2007, click SQL Server in the Move Data group on the Database Tools tab.
  4. In the Upsizing Wizard dialog box, click theUse existing database option, and then click Next.
  5. In the Select Data Source dialog box, select the appropriate DSN to connect to your instance of SQL Server on the Machine Data Source tab.
  6. Click OK.
  7. Enter the appropriate authentication information to connect to your instance of SQL Server if the SQL Server Login dialog box appears.

    Notice that you receive the error messages that are mentioned in the "Symptoms" section, and you cannot continue the upsizing process.
REFERENCES
For additional information about how to use the Upsizing Wizard in Access 2002, click the following article number to view the article in the Microsoft Knowledge Base:
330468 How to use the Microsoft Access 2002 Upsizing Wizard
For additional information about issues with the Upsizing Wizard in Access 2002, click the following article number to view the article in the Microsoft Knowledge Base:
328319 Issues with the Access 2002 Upsizing Wizard
Acc2002 Acc2003 DSN upsized ACC2007
Properties

Article ID: 838594 - Last Review: 09/17/2011 09:16:00 - Revision: 3.0

Microsoft Office Access 2007, Microsoft Office Access 2003, Microsoft Access 2002 Standard Edition

  • kbexpertiseinter kbtshoot kbdatabase kbwizard kberrmsg kbprb KB838594
Feedback
='ms.dqp0';m.content='true';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> ="setLanguage(language);" class="ng-binding" id="language-es-es">España - Español
Paraguay - Español
Venezuela - Español
://c1.microsoft.com/c.gif?DI=4050&did=1&t="> var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" d')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> >