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
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