View Single Post
  #2 (permalink)  
Old March 16th, 2004, 08:58 AM
xgbnow xgbnow is offline
Friend of Wrox
Join Date: Jun 2003
Location: McPherson, Kansas, USA.
Posts: 128
Thanks: 0
Thanked 0 Times in 0 Posts

If you create a public variable in a module (bas) you will be able to access that variable from anywhere within your project. Most of the time I use a global connection object.

Public gCn As ADODB.Connection

I then use a function in a dll/class module to connect to the database I pass the global connection object as a parameter.

Hope this helps.

Larry Asher
Reply With Quote