Custom datagrid paging with Access

hi

i created a datagrid that is binded to an access database. i also made the datagrid page automatically. now i would like to make a custom paging feature, so as not to load the entire search result, but only show the records needed for that page.

i have seen a lot of examples on sql server, but i am not sure how to implement it in access. if you guys have any articles on it or any help i would really appreciate it.

the trouble is with the sql search on the access database, i have all the postbacks etc, coded.

thanks.