Deadly serious, I know, Desmond. Apologies if I was stating the obvious. I feel your pain. It's hard to say what the best solution will be until you know the scope of the problem. Off the top of my head it sounds like the pointer to where the next chunk of memo data is supposed to be written is wrong but there could be other issues as well. My experience has been that Recover seems to handle memo field issues better than Foxfix.
Sometimes you can recover from this problem doing a "copy to" a new table. -- rk -----Original Message----- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Desmond Lloyd Sent: Monday, September 29, 2014 12:57 PM To: profoxt...@leafe.com Subject: Re: VFP6 Severe memo bloat No kidding... On 29 September 2014 11:48, Richard Kaye <rk...@invaluable.com> wrote: > Smells like you still have database/table corruption that needs to be > addressed. Replacing the memo fields that have bad data doesn't > necessarily mean that your troubles are over. You need to run some > repair tool like Abri Recover or Foxfix against your data and see what it > tells you. > > -- > > rk > -----Original Message----- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > Desmond Lloyd > Sent: Monday, September 29, 2014 12:30 PM > To: profoxt...@leafe.com > Subject: Re: VFP6 Severe memo bloat > > Further problems... Now users are reporting that there updates are > not being saved, it's just a replace mymemo with m.mymemo????? > > Yikes, > Regards, > Desmond > > > On 29 September 2014 11:23, Desmond Lloyd <desmond.ll...@gmail.com> wrote: > > > No general fields. I think the damage occurred when I issued a Pack > > Memo, however I didn't run that until after I had encountered the > > first error. (failure to run a report). > > Do you think I would be wise I changing the block size? Sounds like it. > > I've got about 100 users accessing these memo fields (they're are > > nine in the file) > > > > Regards, > > Desmond > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD04423C5C42B4F@ACKBWDDQH1.artfact.local ** 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.