In my query unload event I want to check if the database is still connected. If the DB is connected then a data transfer is in operation and I dont want the user to be able to shut it down until the transfer is complete. The connection is set to nothing at the end of the transfer sub so then it will be safe to close down the app.

I want to say something like
if db1 is open / connected then
cancel = -1 (don't allow)
end if

how can I achive this, I have seen it for a recordset in my VB book

The line : If db1 connected / open then : is what I need to know.

Thanks
Locutus


[Edited by locutus on 08-10-2000 at 11:24 AM]