Making daily backup of database

[JeroenMioch]

Guys,

As my database is growing and hold more and more data i want to make a daily backup to the local harddisk (it works on a network now) automaticly.
The way i want it to work is as follows :

When a user quits the application i want to check if there is a copy allready existing with the date of today.
If it does it skips the copy process and just quits.
If it doesnt, i want it to make a backup in a directory. if the directory doesnt exist it must be made.
The backup file name must hold the date of today offcourse.

I realise that i have to have a procedure to delete obsolete (outdated) backups as well, but ill worry about that later.

Offcourse ive tried this a few times, otherwise i wouldnt ask it here. But i seem to fail every time..

Anyone here that can help me with this ?

[June7]

Maybe this has what you want http://mikeperris.com/access/automat...vba-macro.html

[Dal Jeanis]

1) Are you really trying to have EACH USER back up the entire database every day, to their local directory?

2) How would you know when the backups become obsolete?

3) Is your database split FE/BE, or single?

4) How Big is the database?

5) How volatile is the data? i.e. What percentage of the data changes each day? i.e. What volume of new records are created each day?

6) Have you considered a Windows daily scheduled task, to run after hours every night?

7) You are on a LAN? Have you considered having the backups scheduled to be done automatically by the system group that supports your LAN?

8) Do you have logging of updates in your database? If so, you could set up the system to have the first user of each day begin a task in background to export the log files to a permanent backup location.

[JeroenMioch]

Sorry for the late responce but ive been very busy

A Windows daily scheduled task sounds the way to go.

How would i go about this ?
I see how to run programs and make triggers. But i dont see duplicate in the options.

Thanks for helping.

Greetz : Jeroen

[Dal Jeanis]

Basically, you create a copy script and run that.

[June7]

Use a VBScript file: http://www.ehow.com/how_8794370_copy-file-vbscript.html

Schedule event in Windows Scheduler to run the VBAScript.