[AccessD] Automate backup

[Rocky Smolin]

It would be easy to put a file script Copy in the Click event of your Exit
button on the Main Menu or wherever.  But I don't know how you'd trap that
if they clicked the close window button on the upper right corner.  Although
you could modify the forms to disable the window close button.

HTH

R


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of FW
Salato Center
Sent: Friday, March 03, 2017 7:25 AM
To: Access Developers discussion and problem solving
Subject: [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