Hi guys

When connecting for the first time, I want to hold the details of the database in global variables that can be accessed accross multiple modules, I know I can create public variables within a module but how do it do it across modules?

Many thanks for any help here!

Cheers

Ciaran

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

Hi

Thanks for your help

Cheers

Ciaran