Thanks for your reply Ted - are you after that MRR (Most Rapid Responder) prize that Ed awards from time to time ?
I'm not sure if I have understood you correctly ... if I have a folder that contains, several 10's or even 100's of MB of data, then it seems that you are suggesting that I go through all the DBCs and DBF's in the source folder, copy them to a temporary location and then do the backup of the temporary folder ? Of course whatever I do I have to ensure that I don't end up with backlink issues ... which is why I think that what you are suggesting will reqire me to copy *everything* from the "active" folder to a "target" folder and then do the backup of the target folder ... I need to have the backup contain the tables and the DBCs - and I can't see how, with what you are suggesting, the DBCs in the "active folder" will end up in the "target folder" so that they can be ZIPped ... Am I really, in effect, expected to duplicate the contents of the "active folder" to a "target folder" and then do the backup on the "target folder" ? Paul Newton Ted Roche wrote: > 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. > > _______________________________________________ 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.
