Hi all,

I have access database file with 2 tables,

the tables have the same columns but with different data,

and I have 2 asp files that show the content of each table with

paging recordset,

they have the same code, but only one asp works,

when I try to open the second page i got this error:

Error Type:

ADODB.Recordset (0x800A0CB3)

Current Recordset does not support bookmarks.

This may be a limitation of the provider or of the selected

cursortype.

it doesn't make sense how one asp page with the same code working,

and the other not, any idea wht it happend ?

the code:

Set Conn = Server.CreateObject­("ADODB.Connection")­

Conn.mode = 3

FilePath = "C:\Inetpub\wwwroot­\database.mdb"

Conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & FilePath

& ";

Set RS = Server.CreateObject­("ADODB.Recordset")

RS.CursorType = adOpenStatic

RS.PageSize = 5

RS.Open "SELECT * FROM table1", Conn

Hi,

I'm having a different problem, but the same error message

(ADODB.Recordset (0x800A0CB3) ).

I tried what you suggested, to verify that the provider gave me the

cursor type I had written.

So here's what i wrote:

rs.open sqlStr, con, 3,3

and i got cursor type=0, locktype=1.

Why is that? and what can I do about it?

Thanks for the quick reply.

1. I use MS Office Access 2003 (11.8166.8202) SP3

2. The code of my connection to the DB and the RS:

dim SQLstr

set con = server.CreateObject­ ("adodb.connection"­)

con.open "provider = microsoft.jet.oledb­.4.0; data source =

c:\ak\Akel.mdb"

set rs = server.CreateObject­ ("adodb.recordset")­

SQLstr = "SELECT * FROM tblProperty"

rs.Open SQLstr, con, 3,3