Is there a way to pause program execution in Access VB while an external application is running?
I have written a piece of code to copy a database file to a location, compress it with Winzip, then delete the copy of the mdb file. Since program execution does not stop when Winzip is running in the background, it jumps to the next line which deletes the database copy before Winzip has a chance to compress it.
What I want is for the program to pause long enough for Winzip to compress the file before moving onto the next line to delete the mdb file. Unfortunately, I'm still using the unregistered version of Winzip, so I keep getting the message prior to loading, requiring the user to click "Agree" to continue, and the clever buggers (
) who wrote the program have alternated the Agree and Quit buttons, so I can't use the SendKeys statement to do this automatically.
If there is no way of doing what I want, does anyone know of any freeware compression utilities that allow command-line parameters like the '-a' parameter in Winzip?
I have written a piece of code to copy a database file to a location, compress it with Winzip, then delete the copy of the mdb file. Since program execution does not stop when Winzip is running in the background, it jumps to the next line which deletes the database copy before Winzip has a chance to compress it.
What I want is for the program to pause long enough for Winzip to compress the file before moving onto the next line to delete the mdb file. Unfortunately, I'm still using the unregistered version of Winzip, so I keep getting the message prior to loading, requiring the user to click "Agree" to continue, and the clever buggers (
) who wrote the program have alternated the Agree and Quit buttons, so I can't use the SendKeys statement to do this automatically.If there is no way of doing what I want, does anyone know of any freeware compression utilities that allow command-line parameters like the '-a' parameter in Winzip?
