[AccessD] Using Global Connctions

Hello All,

As a follow up to Susan Harkins discussion on the command object,

How do you guys use a global connection in your apps

What I have been doing is initialising gccnn when I load the app.  It is G
lobal C onstant cnn.

I then use this Global variable for every ADO section of code.

Do you hate global variables?
do you think that they are unreliable?
do you think that someone is going to come in the middle of the night and
wipe it out?
Do you use a class or property pass it around instead?
In a fat client, LAN, does anyone initialise it and close it each time? (I
presume not)

Just intested in your feedback

Thanks