[AccessD] Automate backup

[Jim Dettman]

 Have to keep in mind though that this can yield an inconsistent backup if
the database is in active use.

 JET doesn't lock the main DB file when someone is in, so this can happen.

 As JimB talked about in his post, to get a consistent backup, you need some
method of ensuring that every one is out, and then making sure no one is in
till your done copying the file.

 But with that said, chances are if you backup in off-hours, the DB will not
be active anyway and you'll get a viable backup even if users are still in.

Jim.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Gustav Brock
Sent: Friday, March 03, 2017 10:44 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Automate backup

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. 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com