You can use your module by the CALL argument of whatever you have declared in your module.
At the guy above me:
Have a try on this:
Public Dbconn As New ADODB.Connection
Public rs As New ADODB.Recordset
Public Sub DBCon()
Dbconn.Provider = "Microsoft Jet 4.0 OLE DB Provider"
Dbconn.Open "PNP.mdb" 'where PNP.mdb is the Database Access Name
You can then just use the connection by Call-ing it
And please don't hijack others post. Start your own