hi all
i open an access database from asp .. for some reason i need to know the number of records in the recordset before processing it as follows :

set con=Server.CreateObject("Adodb.Connection")
set rs=Server.CreateObject("Adodb.Recordset")
con.ConnectionString=strCon
con.CursorLocation=1 'server
con.Open
set rs.ActiveConnection=con
rs.CursorType=adOpenKeySet
rs.open "select * from items"
rs.MoveLast
n=rs.RecordCount
Response.Write n

i get an error :

Microsoft OLE DB Provider for ODBC Drivers (0x80040E24)
Rowset does not support fetching backward.

can you help with this ?