Setting up auto backup

  • Thread starter Thread starter jln via AccessMonster.com
  • Start date Start date
J

jln via AccessMonster.com

I would like to find a way in vba to set iso that every time that the Admin
(me) closes the DB that it creates a backup. That way there is always a
current backup.
 
Access has no application-level events, so you'll need to fire off such a
command in the OnClose event of a form. If you already have a Switchboard
form, this will work. If not, you can create a sentinal form that loads
hidden and fires events when it closes.

To do a backup, check out this article by Dev Ashish:
http://www.mvps.org/access/api/api0026.htm

Barry
 
Back
Top