How to eliminate multiple connects to backend db

[speja01]

Hi Everyone,

We have a MS Access application which connects to a DB2 LUW database backend. It appears that whenever the database.OpenRecordset command is executed the application opens a new connection to DB2 to perform the query. Is it possible to just open one connection and reuse it? I believe the constant connect/disconnect is causing some overhead that I would like to avoid. I also noticed that even though I'm issuing the recordset.close and database.close commands the connection still remains to db2. How do a close the connection to db2? Any help would be appreciated.

Thanks

 

[genomon]

After you close the connection, set the connection object = Nothing.

Beir bua agus beannacht!