Close and compact MS-Access Backend

[Ultrawhack]

I have added an Access mdb as my VB2005e datasource using Data | Add new data source, etc.

I would like to be able to compact and repair this mdb programmatically using
http://www.codeproject.com/cs/database/mdbcompact_latebind.asp

The code expressly states that I need to "make sure there's no open connections to your db before calling this method!"

How can I ensure all open connections to this mdb are closed programmatically from within VB2005e?

 

[aBsOlUt]

Check your connections object State property.

 

[vis781]

To be honest UltraWhack i'm a bit concerned that your not sure about the current state of your connections. If you've closed them, then they are closed.