I'd like to know that too. I've coded an asp.net web application using sql Server that I could use function 'Row_number()' to get the rownum. But, in release, I have to change my sql Server based web app to a Access based one. Because the Server Provider did not offer a 'sql Server ' !
Enough moan.. Please, who knows the answer,to this question, or the way to get rownum in access, do please tell me!