NO BOOKMARKS AVAILABLE IF RECORDSET OPENED WITH COMMAND OBJECT

[TNN]

As regards ADO
I am finding out that if I open a recordset with a command object then I am unable to use bookmarks with that recordset. Error message comes back "......not available from provider". If I open the same recordset with the Open method then bookmarks work fine. Does anyone know what's going on there ????
TNN, Tom
TNPAYROLL@AOL.COM


TOM

http://WWW.TNPAYROLL@AOL.COM

 

[TNN]

I have to add to this thread.
Code first: strSQLF3 is a stored procedure

adoRsF3Screen.CursorType = adOpenStatic
adoRsF3Screen.LockType = adLockOptimistic
adoRsF3Screen.Open Source:=strSQLF3, ActiveConnection:=adoConnection, _
Options:=adCmdText

cmd.ActiveConnection = _
"Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=" & App.Path & "\BEMPLOYE.MDB"
cmd.CommandText = strSQLF3
cmd.CommandType = adCmdText
Set adoRsF3Screen = cmd.Execute

I opened the recordset first with the above Open statement. Then I changed it to open with a command object. I then changed back to open again with the Open statement. After changing it back to the open statement the recordset will not open. I get error "invalid operation".

I've done this with other recordsets with the same result. Once I've changed to open with a command object and then back to open with the Open statemant then the recordset will not open.

These are the same recordsets I am trying to use bookmarks with.

Can anyone tell me what's going on ??????
Thank You for any help.
TNN, Tom
TNPAYROLL@AOL.COM

TOM

http://WWW.TNPAYROLL@AOL.COM