• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Does Access support row id or rownum?

 
Satheesh karuppiah
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would like to get the records like (from 1st record to 20th record or 20-30) from access database. I wonder there is no support for rowid and rownum like oracle. Is there any way to retrieve the records like above?

Thanks in Advance.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Satheesh,
Welcome to JavaRanch!

As far as I know, Access doesn't support any easy way of doing paging. You could search for "access" and "paging" to confirm. (I haven't used Access, just read about it.)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic