Automatic Back-ups of MS Access Back-End on Shared Network

[skidawgs]

Hey All,



I am attempting to find the best way to automatically back-up my back-end database file at one week intervals. The be file is located on my organization's shared drive, and currently I simply copy the file and Paste it into a back-up folder. I would like to prevent this from needing to take place to reduce/ prevent required maintenance moving forward.

At first I was thinking a Batch file along with Task Scheduler would be able to do the trick, but from what I can tell, this doesn't work on shared networks. I'd be happy to hear about some of the ways you all have made this possible on your on DBs, or any ideas you may have.

Thanks!
Skid

[Micron]

Not sure about your comment re network shares. There was a dedicated pc for running updates, but that might not be relevant.
I used TS to open a shortcut. The shortcut had a command switch. When the db opened, startup code checked the db Command property. If it was the machine, it went straight to the updating code which first ran a batch file to back up the be. Now the latest data for that day was saved. It then ran a bunch of append and update queries and ran the batch again. Now the most up to date data was backed up. That was all over a network, and the batch file took care of users who had different home drive letters. Those who were native to the server were F:, those who were not native could have any other letter they happened to use when they mapped.

[skidawgs]

Hey Micron,

That sounds like a great solution. I'm going to do a bit more research to see how I can implement this in my situation. I wouldn't be surprised if I have another question pop-up along the way

Thanks!
Skid

[Micron]

NP. It may be worth noting that if you follow that method, TS must use a shortcut with a command line switch; you cannot open the db directly and pass a command property value. The switch can be whatever you want. Mine was Otto Mayshun because I have a warped sense of humour. I also found that the value was padded with spaces for some reason, so it was necessary to use Trim function on the property value.