Automate Backup of backend database
I'm trying to figure out a way through VBA and the ontimer event to send a copy of the backend database to a jump drive every so many minutes. This is in a database that i wrote for the auction industry and the data changes every 30 to 45 seconds. If the network or laptop that holds the backend database crashes i need a quick and viable backup to pull. I'm currently using a batch file but would much rather do it with VBA. Any and all help would be greatly appreciated.
I should probably elaborate a little on this project. I have a form within the database that holds default company information to be used throughout the program. Like the path to he artwork for header reports and the likes. This information is used to set properties of forms and reports from the onopen event. I have 2 fields in the form, 1 for BUFile (The file to be backed up) and BULocation (The location to back the file up to) I have tried 7 ways to sunday to automate this through VBA code and have failed so far. If anyone needs more information, don't hesitate to contact me. I have also subscribed to this topic so i will be notified via e-mail when you post and will get back to you as quick as i can.