Closing ADODC database connection

flutty

Hi all

I'm having an annoying problem with ADODC controls.

I am using them to bind Datagrids to a Access DB, but while the VB project is open (but not running) the database still has an active connection open.

I assume this is being caused by the fact that I am not closing the ADODC connection in my code, but I can't seem to find a way to do this.

I know I could avoid this using ADO objects, but I've had problems using them as the datasource for Datagrids, and got bored trying to resolve it.

ADODC works fine, apart from the fact that they don't seem to close their active connections when they go out of scope.

Any answers would be much appreciated.

Flut

btseb

: Hi all
:
: I'm having an annoying problem with ADODC controls.
:
: I am using them to bind Datagrids to a Access DB, but while the VB project is open (but not running) the database still has an active connection open.
:
: I assume this is being caused by the fact that I am not closing the ADODC connection in my code, but I can't seem to find a way to do this.
:
: I know I could avoid this using ADO objects, but I've had problems using them as the datasource for Datagrids, and got bored trying to resolve it.
:

: ADODC works fine, apart from the fact that they don't seem to close their active connections when they go out of scope.
:
: Any answers would be much appreciated.
:
: Flut
:


****************************************
All you need to do is :

[red](Your ADOC Connection name).Close[/red]