When trying to add a record to a table that has a large number of fields to update, I get the following error:<BR><BR>Error: STR SQL: statement too long.<BR><BR>How do I get around this problem aside from breaking up the recordset into pieces and updating them each one at a time?<BR><BR>Thanks.<BR>Raza.