Backup of data

[aruna2]

Hello all,
I have a web application that pushes data to an access database.
Backups are done on this nightly - but a system failure last week caused a great loss of data due to input of data in the interval between backups.
Is there anyway that as soon soon as the data gets changed in the access database that I can have the data pushed to another file/db on another pc/media on the network... How would I go about setting this up.
I have SQL server 2000 on my own pc and could use this to back up the data. Would it be easier to push it into there and schedule something or would access be sufficient.

Please help - as I really am a beginner on this.

Thanks

 

[WHM]

If backing up nightly is already required, I would reccomend going to mirrored drives on your server. I would also question whether Access is the right product. If you have a small number of records that are continually changing, and less than half a dozen workstations, then Access might be alright, but if you are appending large amounts of new data on a daily basis, it is likely that you will soon out-grow Access. (By small number of records I mean less than 50,000 to 100,000 total records).

Good Luck!

Hunter