BasicQuestion:

If I place this code into a standard module then am I right in saying that variable conn is available to all forms, classes in the project?

Option Explicit
Public Conn As ADODB.Connection