• 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
Sheriff
Posts: 36031
432
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.)
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!