I have a database with a macro that runs a batch file. That batch file is supposed to take the backend database and use the command line version of WinRar to compress the backend, and then invoke a command line email program to email the compressed backend to me.
If I go to the Macros page of the Database window and run the macro from there, it works perfectly. But if I attach that macro to a command button on a form, WinRar errors out saying that the file is in use by another process.
I've tried having my macro close all the open forms, but that doesn't help, either.
Does anyone know why running it from the form verses from the database window would make a difference, and how I can get exclusive access to the backend for my batch file?
If I go to the Macros page of the Database window and run the macro from there, it works perfectly. But if I attach that macro to a command button on a form, WinRar errors out saying that the file is in use by another process.
I've tried having my macro close all the open forms, but that doesn't help, either.
Does anyone know why running it from the form verses from the database window would make a difference, and how I can get exclusive access to the backend for my batch file?
