I support an access (2000) application. I have a request to copy this application to another location from within the application. I have used the the filescriptingobject fs.copyfile, it leaves the app open until the copy is complete. I also created a DOS .bat file to do the copy and I execute this from within the application but it also leaves the app open until the copy is complete. I can physically close the app, but the DOS window stays open. The app is large so it takes about 30 minutes to copy (with the fact that the servers are located elsewhere). I can not leave the app open while this copy takes place. I am running out of ideas... does anyone have any suggestions?
What I would really like is to be able to initiate the copy in the background so it can't be seen and be able to return to the form (where the cmdbutton was to initiate it) and have the user exit the application.
THanks!