how to close all available database connection

[jeremy_ckw]

i would like to know what command or source code is needed to close all available database connection in an aplication. pls help

[Hack]

'DAO
dbobject.Close
'ADO
connobject.Close

[jeremy_ckw]

thanks for ur help. but the code wont help if i wanted to close connection from other forms which the variable is not global. is there any command which i can use to close all connection from other forms.help is really needed

[Hack]

If it is your project, and your objects, they should be available.

Either make the public, and close them all at once, or make them form level, and close them when the form unloads.

[jeremy_ckw]

When the form unloads, what function will it triggers?

I mean...how do I set that whenever a form unloads....it will close the connection?