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
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