doughboy03
asked on
Update failed on recordset
I am using ADO recordset. When I use AddNew method and Update to add new record, the program crash everytime on the update method.
This the error message that show up:
"The instruction at "0x7c9111de" referenced memory at "0x005f0054". The memory could not be "read".
Please help.
Here is sample code:
Set NewAdd_RS_IOF = public_RS_IOF.Clone
NewAdd_RS_IOF.Fields("USER 1_VALUE") = USER1_VALUE
NewAdd_RS_IOF.Fields("USER 2_VALUE") = USER2_VALUE
NewAdd_RS_IOF.Update
This the error message that show up:
"The instruction at "0x7c9111de" referenced memory at "0x005f0054". The memory could not be "read".
Please help.
Here is sample code:
Set NewAdd_RS_IOF = public_RS_IOF.Clone
NewAdd_RS_IOF.Fields("USER
NewAdd_RS_IOF.Fields("USER
NewAdd_RS_IOF.Update
Try using the Microsoft.Jet.OLEDB.4.0
instead of Microsoft.Jet.OLEDB.3.51
instead of Microsoft.Jet.OLEDB.3.51
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Provider=Microsoft.Jet.OLE