Navigation:  Articles > Mar-2002 >

Bad ADP Connections - Moving ADP's Between Machines

Previous pageReturn to chapter overviewNext page

Garry Robinson        

 

NOTE ADP's are pretty close to being a dead duck.  They are not supported in Access 2013 at all

If you open an ADP and the first message you get is

 

Microsoft Data Link Error
 
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied. 

 

200203_adp_tip Figure 1

or

Microsoft Data Link Error
 
Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied. 

This means the server isn't working or you have moved the ADP front-end between machines and the server name is different.

To Solve - OR - Simply Setup Your Correct Connection

Choose File then Connection as in Figure 2.

200203_adp_tip2 Figure 2

Then enter the Correct Name of the Server

200203_adp_tip3 Figure 3

Test Your Connection and Your Database Should Work Fine