I am using ado data controls to link to an access database, but am unable to subsequently close the database connections to enable a database compacting routine to work.
I need to compact the database at the end of the session, and this is proving a challenge. I have been searching for ways that this could be achieved for the last day now, and am hoping that I wont have to re-write my application without the ado data controls. When the compacting routine runs, an error message is generated that Admin is currently using the database. Does anyone know how to release an ado data control connection(s)?
I need to compact the database at the end of the session, and this is proving a challenge. I have been searching for ways that this could be achieved for the last day now, and am hoping that I wont have to re-write my application without the ado data controls. When the compacting routine runs, an error message is generated that Admin is currently using the database. Does anyone know how to release an ado data control connection(s)?