I need to copy tables that have changed on an hourly basis to a back up directory. In this way, if the LAN goes down a relatively up to date back up can be accessed. The problem is if I try to COPY TO, I get a file is in use error. does anybody know of a way that I can accomplish copying an open file without closing it?
-Ed