I suspected as much. :( Is there any workaround to this without adding more conditions to the WHERE clause of the SQL SELECT?

>Correct! VFP's ODBC driver does not support the MaxRecords property.
>
>>I re-read your code, it looks like you are setting the property before you open the recordset. I have used this property with other databases, but not FoxPro. Foxpro's ODBC might not support this.