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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement