Question programmed back-ups

[MikeLeBen]

I am currently about to finish working on a database project and am looking for a way to programmatically save a backup of my database backend every day or so, for instance, on an FTP server.

Do you know if I can do this from Access or can you suggest a 3rd party piece of software that might do the job?

 

[HiTechCoach]

Yes you could do this within Access.

See:
ZIP and Unzip from within your Access Database

FTP Client functions

I would still recommend using a good backup solution. One that does the backup, verifies the backup, then FTPs the file.

I have clients that use this: Handy Backup

 

[MikeLeBen]

I took a look at your samples just for the sake of it, and the programming involved is way beyond my capabilities (for now ).
On the other hand the software you suggested works like a charm and is perfect for my needs.

 

[HiTechCoach]

Yeah .. trying to do it yourself is a lot of work.

I think that using backup software is a wise choice.