>You can't use the ODBC driver with any database or table that has features added after VFP 6, which was the last time the ODBC driver was updated. You'll have to use the VFP OLE DB provider instead. Yes, I'd suggest using CursorAdapters, because they make it relatively easy to convert between ADO Recordsets and VFP cursors.
Thanks