Updating records problem

[Christiana]

I am using this command to update the records rs.AddNew but I get this msg
ADODB.Recordset error '800a0cb3'

The operation requested by the application is not supported by the provider.
When I run the command
if rs.Supports(adAddNew) then%> TRUE
<%else%>FALSE
<%end if%>
I always get TRUE.
Does anyone know what the problem can be?
I thought of using the traditional way of INSERT but I want to get back the primary key of the record added. Is there another way to do it besides
WatermillID=rs.Fields(&quot;WatermillID&quot.Value
PLSSSSSSSSSSSSS help
Thank you in advance
Christina

 

[link9]

What type of cursor are you using?

Check out this FAQ and see if it sheds any light on the subject.

faq333-618

If not, then post back with your code.


Paul Prewett