forward only recordset

[9815402440]

Hi.
I tried using forward only recordset. I am using VB6. I am using ado and Access 2000. It does not generate any error when I use movePrevious method of recordset.
Following is the code:

Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
With cnn
    .Provider = "MsDataShape"
    .Properties("Data Provider") = "Microsoft.Jet.OLEDB.4.0"
    .Properties("Persist Security Info") = False
    .Properties("Data Source") = "e:\data.mdb"
    .Properties("Extended Properties") = "Jet OLEDB:Database Password= 123"
    .Open
End With
rs.Open "select * from Ledgers", cnn, adOpenForwardOnly
With rs
    MsgBox .RecordCount 'Displays 67
    .MoveFirst
    .MoveLast
    .MovePrevious 'No errors
End With

I was just testing ForwardOnly cursor type. I want to know how it is different from other types.

regards
manpreet singh dhillon hoshiarpur

[Killer42]

It might be that forward-only is not supported in your circumstances, and so it opened a "normal" recordset.

(I don't know, I'm just guessing.)

[debasisdas]

Hi.
I tried using forward only recordset. I am using VB6. I am using ado and Access 2000. It does not generate any error when I use movePrevious method of recordset.

Just change the provider and check it throws error.

[9815402440]

hi debasisdas
thanks it worked

manpreet singh dhillon hoshiarpur