Hi Eric,
Thank you for your advice.

Since it's a small app and i have to update 245 fields( belive it or not the table is normalized:) I use addnew method of data control's recordset. I will try to use insert statement but I am not sure if that will work since I suspect the problem is with jet engine.
There is another suggestion on MSDN, to issue 2 rs.update statements, one for the first 127 fields and the second for the rest of them. This is a workaround but may trigger some other problems.

Vlad.


ps: When you say "replace it with insert query", are you referring to a MSAccess Insert-query object or to issuing a insert statement using command object. I assumed you were referring to the last one.