after you're done, perhaps a "pack memo" command to further clean up the mess should be run.
________________________________ From: Kurt Wendt <[email protected]> To: [email protected] Sent: Thursday, February 9, 2012 3:41 PM Subject: RE: USAGE Of Memos, Stability & an Error! In this situation - I don't even care so much about the Memo field contents. They have a prog I wrote for them which extracts the shipping data from an Excel file - and they could simply run the extraction again. Problem is - it seems that the Memo field is affecting just overall access to the records. So - when a program (like a report) tries to run - and copies the required records to a Temp file - its completely crashing out FoxPro. And, needless to say - its Mgmt that generally runs reports - so, they are the ones that are kinda freakin' out on us. At this point - I made a prog that copies out records - based upon a date range - but, the copy actually copies Single records at a time - with a file name that has the Record# as the Suffix. In this way - I can see where the errors occur. Then, I was actually going in and doing a replacement of the Memo field with just a Blank. Am going to see if I can continue to do this - with a copy of their data that we downloaded - and see if I can kinda fix the problem that way... -K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Michael Madigan Sent: Thursday, February 09, 2012 2:24 PM To: [email protected] Subject: Re: USAGE Of Memos, Stability & an Error! Better to go to a backup to recover the memo files. I had a program that would look for non-standard characters in a memo field, which implied corruption, if it found it, then it would replace that memo field with one from backup. ________________________________ From: Richard Kaye <[email protected]> To: "[email protected]" <[email protected]> Sent: Thursday, February 9, 2012 12:53 PM Subject: RE: USAGE Of Memos, Stability & an Error! You need to find out immediately if any of the issues related to SMB/SMB2, hardware/OS caching or oplocks settings are affecting this client site. And based on the discussion, the answer is likely yes if the corruption continues. http://support.microsoft.com/kb/296264 <http://social.msdn.microsoft.com/Forums/en-US/os_fileservices/thread/832d395b-6e6f-4658-8dbb-120138a4cd7c/> http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html http://www.petri.co.il/how-to-disable-smb-2-on-windows-vista-or-server-2008.htm As for data recovery tools, the only one that I'm aware of that is still available is Abri Recover. Actually I don't know for sure that you can't get FoxFix anymore. Either way , recovering data from corrupted memo fields is tricky and your results may not be all that good. Last known good backup may be your best option. -- rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kurt Wendt Sent: Thursday, February 09, 2012 12:37 PM To: [email protected] Subject: RE: USAGE Of Memos, Stability & an Error! Hey Sytze - in regards to your comment #3 below - can you make any suggestions? I hate to admit - that they are TOO Cheap [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.
