>I have only played with the OLD-DB provider and I was able to update data. Nevertheless, I've heard that the OLE-DB provider is extremely sensitive. For example, if the value to update is larger than the field size the OLE-DB provider will choke (rather than truncating the value or telling you that the value is too big for the field.)
>

This behavior is present in most OLEDB providers I've tried. SQL Server, Jet, Oracle. It is not exclusive of the VFPOLEDB.1.