BTW, That insert statement i just posted may very well have some syntax errors in it ( I found a missing "'" somewhere in playing with it), but that doesn't negate the basic problem. Even when the statement is clean, it won't perform the update, either through odbc or from the command box in vfp.

I'm using VB6.0 to generate the code, ado 2.6, the latest vfp odbc driver- 6.1.8629.1, and vfp 6.0.

How long a statement can you have in the command window? When I attempt to update a single (memo) field in the table, I get "unknown command" when the statement exceeds 512 characters.

I am suspecting that I have a configuration problem, because I can't execute the code either through odbc or directly w/in vfp.