What on earth is wrong with this?!?! (ADO/Addnew) 2

[elziko]

I try:

Rec.CursorType = adOpenKeyset
Rec.LockType = adLockOptimistic
Rec.Open "DRTBURST_DATA", ConStr, , , adCmdTable
Rec.AddNew

But get in return:

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

I'm fairly sure that my locktype is fine. See above. My connection string is OK too because its the same one as I've always used:

Provider=MSDAORA.1;Password=xxxxxx;User ID=xxxxxx;Data Source=pdl[color]

 

[SLAbel]

Hello,

I tried your code and got the same problem. I was able to make it work by setting the CursorLocation propety to the client:

rs.CursorType = adOpenStatic
rs.LockType = adLockOptimistic
rs.CursorLocation = adUseClient
rs.Open "GOBI_TitleTemp", cn, , , adCmdTable

'
' Works with a client-side cursor
'
rs.AddNew
rs.Fields("SessionID&quot.Value = "123"
rs.Fields("ISBN&quot.Value = "1234567890"
rs.Update

Hope that helps
scott