>A client has an issue with appending from another table in the same database container.
>
>They've had the same program for years--it zaps the records from mydata97, and then appends from mydata10. It does this for a series of tables in their database--around 60. It's to populate a sample company with their live data. All of a sudden, we're getting the following behavior:
>
>After it appends, it goes to close the file or use another file, and we get:
>
>Error writing to file
>
>And the table usually corrupts itself.
>
>Any ideas?
>
>JR
Joy.
I observed something similra in 1997 in VFP3 for table with memo.
I was able to fix in only by this
removed the table from the database
Put it to separate folder.
Made this table again blank in the database
Made import of old table to new one.
As I was able to undestand, the memo somehow corrupted by problems on the net
and table did not show it, untill I did not append anything to it.
Best wishes, Vladimir
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.