How to make "Bookmark" work in ADO?

I try to use "Bookmark" for my record, but it says my provider may not support this property. I am using my own computer as a server, so how can I change any setting that can make it work?
btw, I can't use RS.absolutepage, .pageCount,....
guess they are all the same problem.

please help me
I am using Windows2000, iis5.0

thanks

Cerebrate

Hi Cerebrate,

The first thing I would check is to see that I am
using ADO and not DAO or RDO.


CG

First, I'm using NT4 and running MSSQL7. See if this code can help you. the MsgBox will tell you if you can use the .seek and/or .index (alternative for what you want to do)

rst1.CursorLocation = adUseServer
rst1.Open "USERTABLE", db, adOpenKeyset, adLockOptimistic, adCmdTableDirect

MsgBox rst1.Supports(adSeek) & rst1.Supports(adIndex)

Dim bk, fg As Boolean
fg = False

If rst.RecordCount <> 0 Then
While Not rst.EOF
With rst1
.Filter = "USER = '" & rst!user & "'"
If .RecordCount > 0 Then
bk = .Bookmark
.Filter = adFilterNone
.Bookmark = bk
fg = True
End If
end with
wend
end if