The current recordset does not support updating.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to update an existing table with a new record using AddNew
and Update. I get run time error 3251: "Current recordset does not support
updating. This may be a limitation of the provider, or the selected
locktype." How can I make the table updatable? Or is the problem in the use
of AddNew?
 
RAHokie said:
I am attempting to update an existing table with a new record using
AddNew and Update. I get run time error 3251: "Current recordset
does not support updating. This may be a limitation of the provider,
or the selected locktype." How can I make the table updatable? Or
is the problem in the use of AddNew?
Click to expand...

What kind of RecordSet did you create? Is it based directly on the table or
on a query? (Many queries are not updateable). Post your code.
 
Back
Top