create an sql connection and use it from different subs and modules

[TSIGOS1]

Hello,
can somebody please help me with the following,
i want to create an sql connection and use it from different subs and modules.
for example:
constr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
FRM_BALCANOR.TextBoxDB.Text & "BOGGERDB.mdb" & ";"

Dim con As ADODB.Connection
Set con = New ADODB.Connection
con.ConnectionString = constr
Dim recset As ADODB.Recordset
Dim cn As ADODB.Connection

and use the same connection which is opened to be used from another vba module and sub.

Thanks a lot

[cyberdwarf]

You could use a global variable to hold your connection string, but I have a question...

Why can't you use CurrentProject.Connection property, as this is valid for all forms/reports/modules in the project? Or are you saying that a connection (different to the CurrentProject.Connection) used with a particular form/recordset will be used elsewhere?

Sorry if I sound a bit confused....

Steve

[TSIGOS1]

Yes ok,
I am trying to open a odbc con from Excel and use it for 2 specific subs.How do I make it global?

[cyberdwarf]

Why are you using ODBC, not ADO?