Are you sure it has to be everytime a user writes data to the local tables? That could be a performance drag, depending on how often they save the data. I think a lot of people use a product called DynaZip to compress the data in zip format overnight. Will that work in your case?

>I think I may need to have a backup facility everytime a user writes data to their local tables.
>
>I was thinking of writing one myself with perhaps writing the raw data to a backup file/table or something, but I don't want to effect performance - although this shouldn't be too much of a problem because it will only be for users with local databases.
>
>Can anyone give me a good recommendation on a backup utility? best to use backup files/tables, when to carry out a backup etc. etc.
>
>Comments welcome.
>Thanks
>Kev