ASP Access Recordset Paging

e.l. wrote:
> 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"

You are not using odbc, so you should have removed those groups from the
crosspost.
>
> set rs = server.CreateObject ("adodb.recordset")
> SQLstr = "SELECT * FROM tblProperty"
> rs.Open SQLstr, con, 3,3

I haven't used Access in a while and I don't have time to test this,
but, from what I can see, you should be getting a static server-side
cursor with optimistic locking. I really cannot see why the provider is
giving you the default forward-only, read-only cursor. My suggestion
would be to change the cursor location to adUseClient (3) which will
force a static cursor to be opened.

Oh, and make sure all database users have Modify permissions for that ak
folder. If your website uses Anonymous access, then the
IUSR_<machine_name> account needs to be granted that permission.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Thanks a lot! You've been really helpful.

What eventually solved the problem was moving the DB from
C:\akel\akel.mdb
to
D:\akel\akel.mdb

I still don't understand why I didn't have access to disc C.

Thanks a lot! You've been really helpful.

What eventually solved the problem was moving the DB from
C:\akel\akel.mdb
to
D:\akel\akel.mdb

I still don't understand why I didn't have access to disc C.

I'm going to guess that the underlying recordset is read-only such as
based upon multiple tables...

Best regards,
J. Paul Schmidt, Freelance Web and Database Developer
http://www.Bullschmidt.com
Access Database Sample, Web Database Sample, ASP Design Tips

*** Sent via Developersdex http://www.developersdex.com ***