Hey,

I'm just wondering how to get the last record of the db, I try the following and get an error....

strconn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="
accessdb = server.mappath("../db/portalDB.mdb")
strconn=strconn & accessdb & ";"

query2 = "SELECT * from test"
set db = server.CreateObject("adodb.connection")
db.open strconn
set rs = db.execute(query2)

rs.movelast 'line 33
rs.moveprevious
lastid = rs("ID")

response.write (lastid)

And I get the following error...

Microsoft JET Database Engine (0x80040E24)
Rowset does not support fetching backward.
/portal/Carnet/ajouter.asp, line 33

Right now I have a crappy work around that works, that I just itterate through the whole db, but that has a bit of an overhead...

rs.movefirst
while not rs.eof
lastid = rs("ID")
rs.movenext
wend
response.write (lastid)

Any help would be great..

in order to get last record change your query as follows:

SELECT TOP 1 * FROM Test Order BY ID DESC

Please do not use rs.MoveLast

Why rs.movelast is such a bad thing?

*rs.MoveLast* I was referring to your code, you do not need to use that. Also, iterating through the entire recordset for finding the last record is also not a good idea. (performance point of view).

Your moveprevious() caused an error because you used a 'forwardonly' cursor. you can fix that by declaring another type of cursor but you headed on the wrong track. If you wanted to get the last ID of a table, you can use the value of @@IDENTITY right after your last insert - this returns the last-inserted identity value. I'm assuming you're using an autoincrement column for your ID field.

Another way is to use SELECT MAX(your_id_column).

'hope it helps.