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.