Hi Keith,
I had this very same problem. We would have 200-300 memo's dissapear in one day, work fine for another month or two and then again another 200-300 would disappear.
We had to do the following to fix the problem. Create a new table, append from the original and then recreate the CDX. This seemed to have solved the problem. At least we have not had a reoccurance in several months.
>I would appreciate any ideas regarding the following mysterious problem:
>
>I have inherited a VFP application that interacts with a FOX DOS application. It saves its data by stuffing it in the memo fields of the FOX DOS tables. It stores multiple 'fields' in one memo by using XML-like tags.
>
>Intermittantly users will get the following: They save data to the DOS memo fields, then return to find it has disappeared completely. This happens about 2-3 times a month, under fairly heavy use. Sometimes the pointer of the memo field in question seems to be corrupt (i.e. pointing somewhere past the end of the .fpt file) but not always. I haven't been able to reproduce the problem or even identify any pattern to the occurances.
>
>Another intermittant problem: The dreaded C0000005 error comes up now and then, again without any clear pattern to it. I did take care to make sure all objects are cleaned-up properly, but this didn't seem to help.
>
>The user workstations are Windows 98, accessing the .exe and data over a LAN, using the Microsoft client.
>
>
>Do you think that concurrent access by FOX DOS and VFP to the same table and memo could be a root cause of these problems, or should I look elsewhere?
>
>Thanks in advance for any ideas.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only