Recordset Move Next

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

I have a recordset that I can move next put not move last. Is ther
a way of connecting to the database (Access) to get around this please.

Set connection = Server.CreateObject("ADODB.Connection")
Set rsTeams = Server.CreateObject("ADODB.Recordset")
dsn = "DSN=Football"
connection.Open dsn
Access = Request("Access")
User = Request("User")
sqlTeams = "SELECT * from Teams"
rsTeams.Open  sqlTeams, connection
Response.Write rsTeams("Name")


Site Timeline