Hi John,
Thank you for your input. I'll try that and see what will happen.
THanks again.
BC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Hi Bernard ---
>
>Assuming that the table is a native VFP table you are querying, the problem is likely the result of a physically corrupt page of data within the table. Write a program using SCAN...ENDSCAN to test key values for validity record-by-record. I think you'll soon find the problem records.
>
>
>>
>>I am running a Select SQL statement from a VFP workstation to extract data from a table located on my NT-server. While extracting the data and once the status bar on the query shows 7 percent completed the query stops running and displays an error. I get this message when I click on Details: Invalid Page Fault in Module VFP500.DLL and Registers numbers and a stack dump
>>Any idea what is happening or why am I getting that error?
>>The SQL statement used to work just fine until today. I have 97 fields in my table with 31000 Records.
>>
>>I appreciate your input - Thanks.