This might help: http://www.objectweb.org/rmijdbc/Access/access.html. I've never tried it, but someone was posting a similar query some time ago and discovered this.
Shinichi <[EMAIL PROTECTED]> wrote:
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 t here 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.c om/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
