You can use the JDBC-ODBC bridge. Since Microsoft Access doesn't run in a
client/server fashion like other databases (it is designed as a single user
database), a pure Java driver to access it would be next to impossible (pure
Java drivers implement the databases protocol in Java, not an interface to
the database engine.. Access doesn't have a protocol, just an interface to
its engine.. the Jet Engine). All ODBC does on Windows is go through the
Jet Engine.
An alternative for you would be to use a three tier approach like
Intersolv's drivers or Borland's Database Engine (that ships with JBuilder).
This allows your clients and the middleware to talk over a pure Java
implementation and the server side handles the ODBC for you.
Access accepts SQL queries over ODBC. It adheres (mostly) to the ODBC
standard. You are able to query Access over ODBC (or JDBC-ODBC) using SQL
just like you would SQL Server or Oracle. There are some limitations,
however. Check Microsoft's documentation on the ODBC drivers for Access to
see those limitations.
Good luck,
Chris
--------------------------------------
Chris Parkerson
Software Engineer, Tools Group
Resident ObjectForms Masochist ;->
Object Design, Inc.
[EMAIL PROTECTED]
--------------------------------------
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Steve
> Buonincontri
> Sent: Wednesday, June 30, 1999 12:45 PM
> To: [EMAIL PROTECTED]
> Subject: Access JDBC?
>
>
> Is there a pure java driver for accessing Microsoft Access Tables?
>
> A better question is:
>
> How do Make JAVA SQL queries on data loaded in microsoft access?
>
> - steve buonincontri
> PWC
> 203-222-7199
> ----------------------------------------------------------------
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If
> you received
> this in error, please contact the sender and delete the material from any
> computer.
>
> __________________________________________________________________
> _________
> 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
>
___________________________________________________________________________
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
