Pagination with MS Access?

Asked Jan 07 '14 at 16:22

Active Jan 07 '14 at 16:28

Viewed 581 times

I would like to page my database over 100 pages, each 1 percent at a time... The only problem is this database is an MS Access database(not by choice). My current sql statement in my code is

$sql= "SELECT TOP 1 PERCENT * FROM [Drive Errors] ORDER BY [Position]ASC";

Is this even possible due to the top function pulling from only the top of the database?

edited Jan 07 '14 at 16:28

asked Jan 07 '14 at 16:22

tjpereira17

Is it important to paginate by percentage instead of by fixed amount, say, 100 rows per page? – mtanti Jan 07 '14 at 16:57
No either way would work, it is just that there are about 4000 rows – tjpereira17 Jan 07 '14 at 17:53
http://stackoverflow.com/questions/1564024/ms-access-limit – mtanti Jan 07 '14 at 20:00

Pagination with MS Access?

0 Answers0