Form based on a Pass-Through Query

[wcboyd]

Hello All,

I am using the Form Wizard to create a form based on a Pass-Through Query, but it keeps prompting me for the password to the ODBC connection. Is there a way to cache the password? Or is this just not a good idea in general?

 

[pbaldy]

Pass through to SQL Server? You should be able to save the password in the connection string (property of the query).

 

[wcboyd]

It is a pass-through to Oracle.
Can I dynamically set the connection string based on input from a Login form?

 

[pbaldy]

I don't see why not. You could use a DAO QueryDef, and set the Connect property of the query.