Check if your Database Connection is open..

[swappy]

if db.open = true then
db.close
End if

I want some code like this where it will check in the form load and if the connection is open , and if it is open it will close it..

[vb5prgrmr]

To help us help you... we need a little more information. Are you using ADO, DAO, or RDO?

[swappy]

ado

[jonc]

You pretty much have it spot on in your first post swappy...
I use this code to check the connection state:

If oConnection.State = adStateOpen Then
        oConnection.Close
    End If

For info, oConnection was instantiated as ADODB.Connection beforehand.

Enjoy!

[swappy]

Thanks a Lot....Thank you..Works perfectly...

I have one more prob here...it would be really nice if you look into it..

http://www.daniweb.com/forums/thread182359.html

Thanks Again