Dear all,



I want to retrieve for instance the rows 10 to 20 in a query from a 

certain table:

I tried this in Access (or using asp script): SELECT * FROM Person LIMIT 

10,20;

This gives me a syntax error, but when I try this in a MySQL database, it 

does the job.

Is there another method to retrieve only a certain range of rows? Or is 

Access the problem?



regards, Pieter