Multiple Usage but Single Connection

[scsii]

Hello guys, To start off with the scenario where i am facing a problem ...

I validate a user and give him access to a particular server with a database.. [ we have multiple serv/dbs ].

In the form where i validate him i make a connection to the database and check for his permissions.. Here i am making a connection to the database..

Now i have many forms which amount upto 20+ where i am checking for some conditional statements by again connecting to the database..This process will be very slow..Since we have already made a connection to the database starting can i use the same connection across all my forms..Doing this will leave the burden of connecting each time to check some validtions....

GUYS i need to know if there is any way where i can use a single connection string which can serve me in all of my forms...

YOUR FEEDBACKS ARE REALLY APPRECIATED...THANX ! !

[faisalkm]

U don't have to connect each time to the server /Db. You can declare a Public connection object in a module so the connection object is available through out the program...

Hope this helps