Not that I know of.
>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.
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams