Hi,
I have developed a program in VB6 which monitors a directory periodically. It then updates an application database on MSSQL-Server6.5. The database access is encapsulated in an ActiveX DLL.

The DLL sets its own connection and talks to the database. So each time the DLL is accessed a connection is established.

My questions are:
1. Is this the best way to do so ?
2. I would like to isolate the data access methods so that I can use the same logic ( DLL ) in other applications. Basically I am trying to separate the GUI and the Database code.

All help is appreciated and thanked