se usi access puoi fare

sqlstring = "SELECT TOP 1 * FROM tabella WHERE status = 1 ORDER BY ID DESC"