Guys, I know there are tons of threads related to this issue, and I've chased several of them without getting an answer, so:

I'd like to compact an Access 2000 db from within my application, using the CompactDatabase method of the MS Jet & Replication Objects 2.x library.

When I execute the method, I'm getting this error:
"You attempted to open a database that is already opened exclusively by user 'Admin' on machine 'COMPUTER'. Try again when the database is available."

I DON'T use bound controls. There are no open connections (I only open connections to create disconnected recordsets and then close the connection [all ADO]).

My questions are:

1. Is there any way to shut down ALL open connections that may be lurking so that the compact method can get Admin access,

2. Is the only way to handle this is by writing a separate DB Admin application that can be executed outside of my app?

Thanks in advance for any responses.