How are you opening you recordsets?
Are you using commands or connections to get a recordset?
If so, you are getting the firehose recordset which is forward-only,
read-only (and I think it's server-side). You can't change it to a dynamic
or keyset even by setting the recordset's properties.
If not, then you should be able to open any type of recordset. Are you
setting the cursortype property to adDynamic or adKeyset
(adodb.CursorTypeEnum) when opening the recordset?
Oh, I forgot, the connectmode of the connection can override the recordset's
properties. Take a look and make sure it allows you to get updatable
Hope that helps,
Quote:> Hi all,
> i am using ADO (2.5, 2.1) with access 97, optionally SQL server
> connecting through their oledb providers.
> how can i get dynamic or keyset cursors?