public ADO Connection 1

[XTnCIS]

This may be simple (I hope) but I'm missing something:

I want to create an ADO connection in code that I can reference/use from other Procedures or Functions.

Right now I can get the connection but when the Procedure ends, the connection can no longer be referenced.

My hunch is that I have to somehow tell the code that the connection is Public?

Any body have experience here?

 

[bluecjh]

try putting i.e declaring the connection as global or public
in a standard code module.

Global g_Conn As ADODB.Connection