I am using ADO 2.1 with MS Access 2000 in an ActiveX environment. I have
four programs running on the same machine as the database. The programs are
writing to the database periodically. One of the programs will do this by
opening a connection loading a recordset with data and then the database is
updated. After the four programs are running for a while one of the programs
will continue to work and the other three will hang waiting to update the
It appears that the one program continuing to run is not terminating the
connection to the database.
The recordset cursor is set to adopenforwardonly and the lock is
My procedure for updating the database is :
LoadData into recordset
Until end of data
I appreciate any insight someone can give me.