Please find the logic for MSSQL below.
Change it in for MS - Access as per your requirement.
Considering your list as
"Id : UserId : ModifiedDate"
;with cteRowNumber as (
select * , row_number() over(partition by Id order by ModifiedDate desc) as RowNum
from YourTable
)
select *
from cteRowNumber
where RowNum = 1