Opening Connection

[Sajid]

Hi Everybody

Can some one tell me where to open and close connection in Visual basic to make my application speed fast

bye

[Mindcrime]

Add a BAS module. Add Public Connection Declaration

Public cnt As New ADODB.Connection

In the Startup object connect to your Database, the connection should last the life time of your executable.

Private Sub Form_Load()

    Set cnt = ADODB.Connection
    cnt.ConnectionString myConnectionString

End Sub

Add connection.close to any Executable termination code you have.

Private Sub Form_QueryUnload (Cancel As Integer, UnloadMode As Integer)
    If UnloadMode > 0 Then
        cnt.Close  
    End If
End Sub

Hope that works!