In my experience, you are going to have to close all the tables you want to backup. It doesn't matter whether you're doing it from inside your VFP application or using an automated tape backup system. Unless you write a program to append the records of an open table to a new table all together, close the new table, backup that table, then erase the new table! In fact, I don't believe you can even copy a file that is open by VFP without getting a "file in use" message, whether from a DOS prompt, Windows explorer, or COPY FILE TO in VFP. Please let me know if you find a way to backup without closing all the tables.

Marcus.


>I work with remote views and for the moment I'm using Visual Fox Pro tables for the Back End.
>My system run in a network. It's possible that two or three instances of the program run at the same time.
>For the backup purposes I decided to use Winzip, sending the commands for it.
>The problem I have is that I get messages from Winzip telling me that some files are open. I know the program itself is using those tables. Then I decided to make the backup in DataEnvironment.AfterCloseTables. But this works if you work with only one program running at a time.
>I will appreciate any idea.
>Thank you.