The sequence is that a copy of the dbf is made with a temporary file name, probably without an extension, and possibly in memory if there is sufficient. The undeleted records are then copied across to the temporary file and the original deleted. The temporary file is then re-named to the original name. BAK is the extension used when the structure is modified, the BAK file is the unmodified one; the TBK extension is the associated FPT file.
Is there an orphan temp file in the temporary work area when this occurs? John Weller 01380 723235 07976 393631 > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Graham Brown (CompSYS) > Sent: 25 September 2007 19:00 > To: [EMAIL PROTECTED] > Subject: RE: DBFs disappearing when PACKing > > > When a table is packed doesn't it copy to a temp name either a > tbk or bak or > something like delete then copy back the other way. > > I have a dim distant recollection that an IT guy I used to work > with created > this problem with a rights problem. Certainly running local should prove > this. > > Also when I pack tables I lock the dbc exclusive as well just to be safe. > > > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Vince Teachout > Sent: 25 September 2007 17:21 > To: ProFox Email List > Subject: Re: DBFs disappearing when PACKing > > > > >> Date: Tue, 25 Sep 2007 11:44:42 -0400 > >> From: "John J. Mihaljevic" <[EMAIL PROTECTED]> > >> Subject: DBFs disappearing when PACKing > >> > >> I'm using a DBF in VFP9 on a machine with Vista Business: > >> > >> USE parts ORDER 1 EXCL > >> > >> When I issue the PACK command, I get a window that reads: > >> > >> File f:\prices9\parts.dbf does not exist. > >> > > > I don't know the answer, but if you do this: > Use Parts Order 1 Excl > Set Deleted OFF > Copy for .NOT. Deleted() to MyTest > > Question: Does Mytest now exist, and if so, is it the same size? > If not I would guess data corruption. > Continuing: > > USE MyTest EXCLU > PACK > > Question: Does Mytest still exist, or is it gone, also? > > > [excessive quoting removed by server] _______________________________________________ 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.
