Hi Humayun, I don't think you can do such advanced stuff with the jdbc-odbc bridge driver. And I have never heard about another driver for MS Access.
If you wanted to use Access, just use Access VBA, or if you wanted to use Java, change your database. I have been had so much trouble using jdbc-odbc driver. On Sun, 26 Jan 2003 06:53:41 -0700 S M Humayun <[EMAIL PROTECTED]> wrote: > Hi all, > > Pls can any one tell me where can i get a suitable driver to work with MS Access >database ? I tried default Sun's sun.jdbc.odbc.JdbcOdbcDriver but it does not allow >scrollable resultset and forward and backward cursor movement at a time. For example >i want to use resultset methods like moveFirst(), absolute(), moveLast() etc. > > Secondly is there any method to get total number records in a result set ? > > Thirdly is there any paging technique u can refer ? like i want to page my result >set records by 10. so that i can fetch a page containing 10 records at a time and can >move forward and backword with page as a min unit ? > > regards, > > Humayun. > > ___________________________________________________________________________ > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body > of the message "signoff SERVLET-INTEREST". > > Archives: http://archives.java.sun.com/archives/servlet-interest.html > Resources: http://java.sun.com/products/servlet/external-resources.html > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html Shinichi ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
