Cannot update current Recordset?

[screaming_banjo]

I am getting this error:

ADODB.Recordset error '800a0cb3'

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

/rogues.asp, line 65

Here's line 65:

rsRogDetail("rogContact") = request("txtRogName")

Here's my SQL:

Set rsRogDetail = Server.CreateObject("ADODB.Recordset")
rsRogDetail.Open "SELECT * FROM tblRogDetail WHERE rogID= "& request("rogID") &" ORDER BY rogContact", conn, adOpenKeyset, adLockOptimistic

Anyone got any ideas why I'm getting this error, I don't think there's anything wrong with my code!

Thanks in advance.

[beta]

Check that the username that you used to connect to the database has the necessary access rights.

[lmf232s]

change adOpenKeyset to adOpenStatic

[lmf232s]

you may also want to use adOpenDynamic.

i use OpenStatic but after reading this link it appears that OpenStatic should not be updateable either but it works for me.

http://www.psacake.com/web/et.asp

THis will give you info on the 4 and maybe someone else can explain the difference. I can read it from the link above but that does not explain whey openstatic says that it provides a non-updateable set of records, yet i am able to do updates to the database using this method.