Keep ODBC Con Open so it Logs In Once for All Forms

[Fattire]

How do I keep an ODBC connection open so that any form can use it to extract data from an external at any time rather then having the Access DB log in the the external DB on every form?

The DBA's are upset that my db's are loging in 200-300 times a day from my users into the Oracle DB and want me to have the DB just log in when the DB opens so that it doesn't log in everytime a recordset is populated.

 

[PHV]

You may have a startup hidden form opening the connection.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Fattire]

I like that idea.. let me try it out - thanks PHV (again)