access database backup...

[alex_raju]

hi,

is it possible to backup ms access database daily updating data only separately


date wise file?

[rpeare]

Why not just automatically copy or zip your database each day through windows task manager (or something similar)

[alex_raju]

Why not just automatically copy or zip your database each day through windows task manager (or something similar)

hi, can u explain little more clearly ( step by step)

[rpeare]

If you know anything about batch files that is the easiest way to handle it.

Let's say your database is in:

c:\access_databases\MyDatabase.mdb
and you wanted to back up the database to
c:\access_databases\backups

if you had a batch file (the easiest possible would be to just copy the database)

you would have one line in your batchfile

copy c:\access_databases\mydatabase.mdb c:\access_databases\backups


Then go to
START>CONTROL PANEL>SCHEDULED TASKS>ADD SCHEDULED TASK

From there it should be fairly easy to run the batch file

[alex_raju]

If you know anything about batch files that is the easiest way to handle it.

Let's say your database is in:

c:\access_databases\MyDatabase.mdb
and you wanted to back up the database to
c:\access_databases\backups

if you had a batch file (the easiest possible would be to just copy the database)

you would have one line in your batchfile

copy c:\access_databases\mydatabase.mdb c:\access_databases\backups


Then go to
START>CONTROL PANEL>SCHEDULED TASKS>ADD SCHEDULED TASK

From there it should be fairly easy to run the batch file

yap i got, v.nice idea...but see if. why i asking to save date date wise if any mistakes we can change only that date, in your way is it possible?

[rpeare]

I'm having trouble with your english, but if you are worried about mistakes happening to your data and you want to restore data you will have to have some method within whatever your backup procedure is to keep track of different days worth of backups.

For instance, what if you need to restore data from a week ago?

The example I gave you you would be out of luck because you are only keeping one archive.

A much better idea if you are worried about bad data getting into your tables is to PROGRAM YOUR FORMS to avoid any possible logical error.