>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.
If the file is open shared, there are a number of ways to back up. We use CA-ARCServe as a backup system at our office; except when files are opened exclusively, both version 4.02 and 6.1 will back up files opened on the network where there are no segment locks in place. In VFP, you can also open files SHARED and copy them to another location; again, as long as noone holds the file open exclusively, DBF files can be opened and copied using USE...SHARED in conjunction with COPY TO...WITH PRODUCTION to recreate the necessary indexes on the target system.
I'm not sure what WINZIP does as far as opening files, so it may be that another product is needed, but open files in and of themselves aren't necessarily a problem.
>
>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.