Hi there,
i write a program in VB6. I create public Ado Connection variable in a module.It connects to Db when the form is loaded. but when i disconnect it. Database is still open exclusively. I just wonder...
Anyone can help.? Please wellcome.

Pheap

hi there..
can you put some code here??
do you unload the form and the conn is still open??

or you close your program and the conn is still alive???

HTH

Gonzalo

Hi,
It is simple when the form is loaded the connection alive. And i use the code to disconnect it (gAdoConn.Close;
  Set gAdoConn = Nothing)
If i close it in Form load even, the connection die,but if i load another form(last form still loaded) and i disconnect it(gAdoConn.Close) it still alive.
Anymore questions welcome...