[AccessD] Automate backup

[Gustav Brock]

Hi Susan

You can set up a scheduled task and/or a shortcut that calls a bat file than runs a simple file copy to a shared folder or USB drive. Can't possibly be simpler.

That's what we do at several clients. Then encrypt the file, zip it, and FTP it to a server of ours - to have an additional copy.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af FW Salato Center
Sendt: 3. marts 2017 16:25
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: [AccessD] Automate backup

I have a small 2007 database on a shared drive that only a few people access infrequently. I need to upgrade it to 2016, but that shouldn't be too bad. I also want to add a routine that creates a backup automatically when the accdb file is closed - regardless of how it's closed. The db isn't split - I know... I know... but trust me... in this case, it just isn't warranted.

The interface now has an option to create a backup, so it shouldn't require a lot of work, but I'm not finding any code snippets for this - everything I've found is old and insanely convoluted.

Any help?

Susan H.