Backup utilitiy?

  • Thread starter Thread starter JamesJ
  • Start date Start date
J

JamesJ

Is there a backup utility or Ad-In that will back up my db and save only
say,
3 backups. I use the backup in Access 2007 but I need to go to the backup
folder
periodically and delete obsolete backups.

Thanks,
James
 
This would be the type of thing you'd need to program yourself.

In the past I setup a simple batch file to do a backup of the db at night
when no one would be using it and then setup the db to delete old files.

If you date stamp your backup it is easily to check the date and delete
those older than 3 days (in your case) using the kill().

But I do believe you'll have to create your own method/solution. if you
give some more details, other people may be able to give you there ten cents
worth.
 
I have a front end and backend db that I backup to folders,
one for the db ui and one for the data. I want to check to
see how many backups there are and if a certain number,
say 3 to delete the oldest and then backup.

Thanks,
James
 
I opt for a low tech transparent backup scheme such as you seek, There are
scripts available that handle both the backup and which also start deleting
the oldest ones based on criteria that you set for max # of copies or max
age.
 
This can be done through access using vba and FSO programming or you could
simply create a vbscript and execute it along with the file copy script
(Backup script) at night.

To copy/backup the db take a look at
www.cmmguys.com/misc/cmmguys/backup.vbs
http://www.michaelhorowitz.com/backupscript.html

To delete older copies, take a look at
http://www.visualbasicscript.com/m_24024/mpage_1/tm.htm#24043
http://www.tek-tips.com/viewthread.cfm?qid=917257&page=9

most of the code can also be incorporate in your db if you want to run it
from there, but do not copy the active db, it may become corupt. that is why
in this case the filecopy should be done using a scheduled task and vbscript
at night.
--
Hope this helps,

Daniel Pineault
If this post was helpful, please rate it by using the vote buttons.
 
Back
Top