Update: at the moment we have 2 batch files to up and download the dbase. Obviously minimal security due to username and password being passed on one of the lines. Can any bat file experts offer a way to prompt the user to enter the password please?
It would also be good to call MS Access AFTER download is complete. I cannot find a batch file command to wait for execution.