my dog learned polymorphism*
The moose likes JDBC and the fly likes Does Access support row id or rownum? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Does Access support row id or rownum?" Watch "Does Access support row id or rownum?" New topic

Does Access support row id or rownum?

Satheesh karuppiah

Joined: Dec 19, 2006
Posts: 1
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
internet detective

Joined: May 26, 2003
Posts: 30136

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.)

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
wood burning stoves
subject: Does Access support row id or rownum?
Similar Threads
Problem while displaying the LIst in JSP
oracle record fetch
How can a rownum help in implementing Pagination
Optimising Pagination
using rownum with union