Real Time Incremental Back Up

[GrnMtn7]

What are the inherent dangers of using an administrator linked database that houses mutliple make table queries (to the backup database) which are called by forms on timer intervals. I want to be able to back up my database hourly without having to boot people out constantly, and came up with the above solution. I am a bit concerned there is some lurking evil i have not thought of.

[Toyman]

What are the inherent dangers of using an administrator linked database that houses mutliple make table queries (to the backup database) which are called by forms on timer intervals. I want to be able to back up my database hourly without having to boot people out constantly, and came up with the above solution. I am a bit concerned there is some lurking evil i have not thought of.

We have an operation form that is opened all the time. In it is a timer to refresh the page and to do a back up every ten minutes. The code copies the backend file and paste it into a remote server. We have been using this for several months and it seems to be working fine. The only thing is to write a line of code to check if the backend is still in good working order before copying it. We had one incident where the backend had become currupted and the code copied it as the backup. When we found the curruption in the backend, we tried to use the backup and found it was also currupted.