Hello Humayun, There are a few commercial JDBC-ODBC bridges available (for example from Easysoft), that might or might not do what you need. In general, with MS Access you're pretty limited - after all it's a desktop database. An option is to scale up to MS SQL or MSDE and use the Microsoft JDBC driver. AFAIK (not sure) it's out of beta by now.
Markus -----Original Message----- From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of S M Humayun Sent: Sunday, January 26, 2003 8:54 AM To: [EMAIL PROTECTED] Subject: [EMAIL PROTECTED] 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.445 / Virus Database: 250 - Release Date: 1/21/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.445 / Virus Database: 250 - Release Date: 1/21/2003 ___________________________________________________________________________ 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
