access 2003 auto backup

Recently saw a DB system that seemed to automatically backup, however there was always only one backup in the drive, so i am assuming it always overwrites the previous backup.  This was done on an automatic basis, I don't know if it was everytime the system was closed by a user or on a daily basis when the system was closed.  Anybody have any idea how to set this up?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

There are many ways to backup a database. Depending upon how critical your database data is, you can as many of the techniques below that you want.  

This is what I do to back up our database.  It may seem excessive but the data is critical to our business and I am very paranoid having been a system's engineer through the 70's and 80's when hard drive crashes were common.

The backend is stored on a raid 7 disk pack.  The server will email me if there is a problem.

Every half hour that the frontend is running, the frontend copies the backend to a raid 0 disk pack by shelling to the DOS copy command.  The DOS copy command will copy an open file.  The only time the copy is corrupted is when someone writes to the backend during the 30 seconds the copy is being made.  The database deletes copies that are more than two hours old so I always have the last 4 copies.  The database will email me if it runs into a problem.  (These copies are very useful for things like a user saying, "I just accidental deleted everything in a memo field.")

Every night, a workstation runs MS backup zipping a copy of the BE to its harddrive.  I keep all these backups for the last four months.

Every night, another workstation runs Second Copy ( zipping a copy to a ftp site on our hosted site.  Second Copy will email me if it runs into a problem.  The data center is in California.

Every night, a third workstation runs Handy Backup which compacts and repairs and then zips the file to a ftp site on my hosted site.  Handy Backup will email me if it runs into a problem.  The data center is in Pennsylvania.

I also look in on all the backups a couple of times a week.  This way, I am not relying on one computer or one piece of software for the backups.  I have automatic offsite backups at opposite ends of the country.  All of this has cost me $50 for Second Copy and Handy Backup and $9 a month for two hosted websites (which includes my websites and

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LadyHagoodAuthor Commented:
Cool. i will look at those web sites this morning if i get a chance, second copy and handyback up.  Thanks.

Also, thenelson, you have answered a few of my questions and  have looked at your site andi was just wondering if you would have advice on some classes to take to reach "expert" level for access and sql server? Looking to do some formal online class.  Do you have any to recommend?
"advice on some classes to take to reach "expert" level for access and sql server"
It would be better to post this as a separate question. You could also do an EE  search on this subject as if has been asked many times.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.