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.
Tim Westmoreland
Software Engineer
Skyline Technologies, Inc.
"Upper classes are a nation's past; the middle class is its future." - Ayn Rand, Russian-born author (1905-1982).