select top 6 * FROM

myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("wars\clanwars.mdb")
Set rs = myConn.Execute("select top 6 * FROM played_war ORDER BY WarID desc")

Prøv det her

Jeg brger selv denne

Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("database.mdb")
Conn.Open DSN

strSQL = "Select top 3 * From nyheder Order By dato Desc"

myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("wars\clanwars.mdb")
Set rs = myConn.Execute("select top 6 * FROM played_war ORDER BY WarID desc")



hmmm den virker ikke alligevel

har du prøvet min, du skal skifte nyheder og sort by dato osv ud med dit eget