Run-Time Error '3704': Operation is not allowed when the object is closed

[elbartje]

I got a problem:

I want to connect to a data bank.
If the connection fails or I get an error
I use this:

On error goto close_databank

close_databank:
close connection

Now when this hapens and he jumps to close_databank then I get a new error:
Run-Time Error '3704':
Operation is not allowed when the object is closed

How can I say when error 3704 don't close connection
Or check if connection if open if true then close else nothing ?

 

[starl]

Use an IF statement to check the specific error number. If it's closed - then you don't try closing it. Assuming 3704 is the error for closed

If err.number = 3704 then
'already closed
else
close connection
end if

 

[elbartje]

ok thank you !