Article ID: 838594 - View products that this article applies to.
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.
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:
Additionally, when you click OK on the error message, you receive the following error message:
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.
NoteThis problem occurs when your Access database and the instance of SQL Server do not exist on the same computer.
The Upsizing Wizard only works with Microsoft SQL Server (Versions 6.50 SP5 or higher). Please log in to a SQL Server data source.
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:
Steps to reproduce the problem
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:
330468For 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:
(http://support.microsoft.com/kb/330468/ )How to use the Microsoft Access 2002 Upsizing Wizard
(http://support.microsoft.com/kb/328319/ )Issues with the Access 2002 Upsizing Wizard