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


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