>>>The strange thing is that if Ole Db would be causing the problem, how come no problem updating my test.dbf?
>>
>>Do you have default values in your main table or is it involved in RI? Does it have AutoInc field? Or some new data types, such as blob?
>
>None of the above.
Test if the table has duplicates in PK or some other corruptions.
If it's not broken, fix it until it is.
My Blog