On Feb 6, 2008 7:13 PM, Paul Newton <[EMAIL PROTECTED]> wrote: > open tables and > databases cannot be backed up. And trying to close them before doing > the backup and then re-opening them after the backup is a complete > nightmare scenario ...
If it breaks when you do that, consider not doing that. Rather than backing up the running files, use a VFP program to scan through a list of all of the DBFs, execute a USE AGAIN NOUPDATE and COPY the contents to a target table which you then close. Then backup the target. As long as you don't have tables opened exclusively or transactions in effect during the backup, that should do the trick. Bonus points if you eliminate deleted records and write the new table in sorted order. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
