I can't figure out how to get my MS Access 2007 ADP file connected to a remote sql server 2008 Express server.
I got it working fine in Management Studio, so I know my connection works.
I have a server name, not IP, like staging.server.com
It works fine in Man Studio but I was able to specify a TCP/IP connection. Is that the problem?
I'm entering the server name like in MS, user and password, and then trying to test the connection. It is using port 1433 which should be correct.