ADO connection damn slow

My condition:
every single form in my application on form load i've got to establish connection. The communication in this application consist between one menu application(*.exe) with varity of other application(*.exe)- using windows shell.
Formerly i'm using Delphi which is easier to uses unit (Unit pascal), I haven't try ADO yet with Delphi. But i think the concept of the connection might be the same in VB.

My question:
Is it posible to me to establish connection once at appliaction first loading then use it on any form that i like within the application? Can you tell the concept or the procedure.


-Khamal-

[SteveFlitIII]

Create an application Class Module that is called from sub main at startup. use this class to set all your global project properties like application name, database connection and disconnection etc.

[Clunietp]

use a single, global connection object for all of your forms (assuming you are only accessing 1 database)

Thanx for both of you, Steven and Clunietp....

One final question to clunietp. Do you really work with Microsoft? If no then Microsoft should employ you Thanx to all for the tips. The idea on Class object is interesting (As Object....cool).

Khamal

[Clunietp]

No, I don't work for MS...

A Microsoft developer is a person who develops with/specializes in different MS tools and technologies (like VB, ASP, SQL Server, MS Access, MTS, etc)

I develop solutions using many different MS tools, so I would be called a Microsoft developer, instead of just a Visual Basic developer. (although VB is my specialty)

Thanks for caring!

Tom