Access cannot connect to any SQL databases

  • Thread starter Thread starter Alex Stevens
  • Start date Start date
A

Alex Stevens

Hi,

I have an issue at a client's site where a couple of computers (out of 30+)
are unable to connect to an SQL server from an Access Data Project.
On the computers in question, I tried to check the connection manually using
File>>>>Connection, but it just hangs.
I also created a new Access Data Project (Existing Database) and this gave
the error "Microsoft Access cannot find the database on the server".

This error appears after saving the new adp file, and it never gets to the
dialog which I actually enter the connection information.
I've tried it using both the ADP that is in use there and with a brand new
ADP. I am able to create a UDL file and connection to the SQL Database that
way though!!!

Has anyone else had this problem, and managed to solve it?

Thanks

Alex
 
Just guessing here,
check the versions of the SQL ODBC drivers if using odbc on a good and
bad machine...

is the logged on user allowed access to SQL
 
Access has been removed and reinstalled.
The problem is definately with Access, as I can't connect using a new data
project.

Alex
 
I don't think there is a problem with the SQL ODBC drivers, as I can create
a UDL and link no problem.

I'll check the user login, but I would have though this would cause an error
at the point of connection.
Access won't even bring up the connection dialog.....

Alex
 
This is what I would check.

1. Can you ping the server
2. Download the MDAC component checker from Microsoft and verify your MDAC
components are the correct version.
3. Verfiy the said computers do not have windows xp or other firewall
blocking port 1433 and 1434. Easiest way is to disable the firewall
temporarily and see if you can connect. If this is the problem you can
configure the firewall to allow traffic on those ports through. If you are
using a named instance the port is going to be different.

HTH
 
Back
Top