unable to connect to adp database

[NuJoizey]

I have an adp file sitting on a remote machine that everyone in the office can connect to just fine except from one pc. The adp file points to an sql server instance

On one computer, no matter what I do, I get

Access is unable to connect to 'MYDATA' database on the 'Scripts_SQLServer' server.  Make sure that the database still exists and that the server is  running

I think I've isolated it to be a machine issue. I don't think it's a permissions issue, because I can get into the db logged into windows as that user from any other pc in the office. conversely, if i log into this particluar
pc with any other user name that can access the db with no problem, I get the error. I've tried reinstalling access (runtime version), but that didn't work

something at the computer level on this users pc is not letting the connection take place, but what could it be?

 

[jrbarnett]

Could it be a system ODBC connection? This would affect a PC regardless of whoever was logged on.

If that user with problems logs on to another PC and there are problems, it may be a user data source issue.

John