I have an Access 97 database and “shell” out to a Dos program to import data from the serial port (proprietary app). I need to know how (In Access VBA code) to check and see:
1. If the Dos program is still running or not. Checking for any Dos box being open would work just as well as there are no other Dos box apps ever running.
B. How to shut it down. Keep it mind when shutting down a Dos program that is open you get a dialog box asking if you are sure if you want to terminate because you might lose data (blah, blah, blah..). So I also need to (in code) avoid or answer this box “yes” so it shuts down.
This problem has plagued me for a couple years now so “Good Luck”!