Access cannot connect to any SQL databases

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
 
S

SJ

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
 
A

Alex Stevens

Access has been removed and reinstalled.
The problem is definately with Access, as I can't connect using a new data
project.

Alex
 
A

Alex Stevens

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top