I am getting the following err messages when inserting a new record into MS Access table.

Err.Number : -2147217887
Err.Decription : Multiple-step OLE DB operation generated errors.
Check each OLE DB status value, if available. No
work was done.

table design :
----------------
Name(text)
Addr1(text)
addr2(text)
place(text)
Cell(text)

I have not given any values for the fileds : Addr1,Addr2, Place, Cell when inserting into access table.

Note : Except the name field the settings of the other field are
“Required = No”
“Allow Zero Length=No”


Code :
-----------------------------------------------------------------------------
rs.Open “addr”, cn, adOpenDynamic, adLockOptimistic
rs.AddNew
rs!Name = txtName.Text
rs!addr1 = txtAddr1.Text
On Error GoTo errHandler
rs!addr2 = txtAddr2.Text (err in this statement)
rs!place = txtPlace.Text
rs!cell = txtCell.Text
rs.Update
rs.Close

-----------------------------------------------------------------------------
any tips?