Hi H anonymous
I believe Peter is on the track here.
Your string should contain no quotes and must contain all connection
info as SERVERBASE, DATABASE etc.:
ConnectString = "DSN=contact;;uid=mylogid;pwd=mypass;"
The trailing semicolon may also be needed.
/gustav
> for linking tables in Access
Hello,
for linking tables in Access through VBA, I'm doing the following with a
login form:
1. I open a database connection:
"Set dbsodbc = DBEngine.OpenDatabase("Test", dbDriverNoPrompt, False,
GetODBCString)"
where GetODBCString =
"ODBC;DSN=Test;SERVERNODE=xxx.x.x.x;DATABASE=Test;UID=User
