Linkd Access Table - The search key was not found in any record

[sra2786]

I am linking to a FoxPro table and I get the error "The search key was not found in any record" when I executed a query against the table. I found the reason for the error is because there are four records that have the value "#Deleted".



How can I write SQL code to skip these four records. I can use TOP to get the records before these records but I do not know how to select the records after these four records.

Thanks.
Sandy

[isladogs]

Try relinking the table. It should only find records that exist.