Row_number and Partition By in Access DB

Question

I have this piece of code that I am trying to run on Access DB and getting a syntax error. I suppose Row number and Partition By does not work in Access. I was hoping I can get help in writing this in an alternate way so I can run in Access.

SELECT *
,ROW_NUMBER() OVER(PARTITION BY s.ConstraintId, s.unitid ORDER BY s.SF desc) as RN2
from genoutages g
inner join shiftfactor_report s on s.itemid=g.unitid