I am writing code to redirect my connection properties for the tables I have to different servers. (My offline server for development vs. the live server) No problem with redirecting my connection but it does not save the login & password I pass it.....even if I clicked Save Password when I originally linked the tables in.
The syntax for the connect property is as follows...
"object.Connect = databasetype;parameters" where parameters are supposed to be for a string you can pass to the ODBC.
Is there a parameter string I can pass that will tell it to save the login & password I send? I'll be using several online servers so I wanted to avoid having to login for each server when accessed the first time.
Thanks.....Toga
The syntax for the connect property is as follows...
"object.Connect = databasetype;parameters" where parameters are supposed to be for a string you can pass to the ODBC.
Is there a parameter string I can pass that will tell it to save the login & password I send? I'll be using several online servers so I wanted to avoid having to login for each server when accessed the first time.
Thanks.....Toga
