ODBC Connect String

[Guest]

Hi,

I have a DB with several ODBC linked tables.

Using Code, I am 'Executing' queries using these tables but require a
password each time.

How do I build up a connect string to use in my SQL to save me having to
re-type the password?

e.g.

strSQL = "SELECT * INTO TEMP_TABLE FROM tblODBC"

db.Execute strSQL

Many thanks,
Steve.

 

[Guest]

You can set the connections in your code and pass the user name and password

If you do not know how to write connection strings in code read the following:

http://support.microsoft.com/kb/q193332/