Hi David,
the error is most likely caused by bad hardware or cabling. Have you tried, after making a backup first, to PACK MEMO? Or ZAP followed by APPEND FROM mybackup?
>I am receiving a fata error (C0000005) when trying to create a 'good' copy of a table. This occurs when I try to create the new table using the 'COPY TO' command, so I then try to create and populate the table using the following code:
>
>
>****
>use LOTS
>COPY STRUCTURE TO 'LOTSTEMP' WITH CDX
>use LOTSTEMP in 0
>
>select LOTS
>GO TOP
>
>DO WHILE !EOF('LOTS')
> SELECT LOTS
>
> SCATTER MEMVAR MEMO
>
> SELECT LOTSTEMP
> APPEND BLANK
> GATHER MEMVAR MEMO
>
> SELECT LOTS
> SKIP
>ENDDO
>****
>
>The error is occurring on the GATHER command on specific records. Once I know which records are offensive, I can proceed by skipping (not GATHERing) records that cause the crash, but there are so many that it almost becomes a moot point to try to recover.
>
>I have two questions:
>
>1) What in the world causes this corruption?
>
>and, most importantly
>
>2) How can I recover my data?
>
>Thanks very much for any help.