Testing a connection to see if it works

[fasi]

You can also use the following code to test the connection say cnn is your ado connection

you can use

if cnn.state <> adStateOpen then
    msgbox"Cannot open the connection"
endif