Last record in Access..

[Markus Mühlich]

Sorry,

1.)
strSQL = "SELECT Last(tabelle.ID) AS [LastID] FROM news;"
set rs = db.execute(strSQL)
myVar = CInt(rs("LastID"))
strSQL = SELECT tabelle.* FROM tabelle WHERE (((tabelle.ID)=" & myVar & "));"

set rs = db.execute(strSQL)

_Recordset auslesen_
db close
set db = nothing
set rs = nothing

Gruß
Markus