Jetcomp.exe

[Frankie Botts]

Does anyone know if Jetcomp.exe can be run asynchrosously? I have written a
wrapper application for my clients to easily Backup and or Compact thier
databases themselves (They're Non Techies) using a very user-friendly GUI.
However I need to "Shell" out to Jetcomp.exe and still be able to "DoEvents"
so to speak. Jetcomp doesn't "return" control to my VBA code until after it
is finished compacting.

Thanks in advance for any help you can provide.

 

[Douglas J. Steele]

See http://www.mvps.org/access/api/api0004.htm at "The Access Web" for how
to wait until a shelled process has completed.

However, I've never needed to shell to Jetcomp.exe: I always use the
CompactDatabase method of the DBEngine object.

 

[Douglas J. Steele]

I just glanced the code but doesn't it make the shelled process
*synchronous*?


Again, isn't that *synchronous*?

FWIW I don't think there is an obvious ADO solution. Although ADO
supports asynchronous connection, fetching and execution, Jet
Replication Objects (JRO) has no events

You're correct. I misread his requirements.

I don't believe there's any solution either.