I'm working on a project which requires me to connect to a remote Access database on a server, using C++ (not MFC). I've written some code to connect to a LOCAL Access database file on my own machine and everything works fine. I can't seem to figure out how to get ODBC to talk to a remote Access database though (ie located at www.myurl.com\myDatabase.mdb). Can anyone suggest what I might try to get this to work?

To make the local Access database connection I used the function called SQLDriverConnect.

I tried modifying the connection string to include the keyword SERVER=www.myurl.com but for some reason I just get this error message:
IM006:1:0:[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
01S00:3:8:[Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute SERVER

It looks to me like I can't use SERVER with the SQLDriverConnect function?

Any help would be greatly appreciated, thanks.