Andy,

ADO is new for me but I try to help you.

ADO need a OLEDB provider to access data.
In VFP this provider is ODBC.
And so far I know SQL is the only way to read AND Write data with ODBC.

Just a question.
Is your code running with another OLE DB Provider ?

Marcel