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]
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]