I am a beginner but have to use the Dreamweaver MX 2004 to complete my assignment on web based application system. My problem is... I don't know how to display the last record from my database (Access XP ). I use the " Recordset.MoveLast" but got an error 'Rowset cannot ... backward'(something like that...). After that I include the adovbs.INC file but got another error.

I think it's
<%=(rsyourrecordset_last)%>

Why not filter the database by ID? <pre id=code><font face=courier size=2 id=code>SELECT * FROM table ORDER BY Id DESC</font id=code></pre id=code>

SELECT top 1 *
FROM tablename
ORDER BY id desc

that'll work but it sounds like you have change your cursor...

default setting is you can only move forward through a recordset...
if you need to move from one record to previous you need to change your cursor type to = 3



Tommy Gibson