>I create a linked server with VFP ODBC driver in MSDE to a VFP table which has some memo fields.
>
>SELECT, UPDATE and DELETE (with OPENQUERY...) works fine, but INSERT doesn't. If I modify the structure of a DBF and delete all memo fields, INSERT works.
>
>Is there some workaround about memo fields with INSERT command?
A while back I couldn't get insert to work in this situation so I switched to VFP OLE DB provider. It's not supported option but it did work for me until we moved the table to SQL Server. Fortunatelly, I only had to do insers in that linked server.
--sb--