accessing mdb files via java

[srikanthr]

Is there any way to read standalone mdb files using java. i.e NOT
connecting to the database via jdbc. i've searched this forum but found
very old posts. Any pointers will be helpful.

 

[Douglas J Steele]

Realistically, getting at the data contained in an MDB file using another
client such as Java or Visual Basic or .Net doesn't actually have anything
to do with Access. You're going through Jet to get at the data, and while
Jet is include as part of Access, it's really a separate component. I think
you may have better luck asking on a Java forum.

 

['69 Camaro]

Hi.

Is there any way to read standalone mdb files using java. i.e NOT
connecting to the database via jdbc.

You can use the built-in JDBC classes, or you can write your own classes
that automate an application that connects to an MDB file, or you can write
your own database connectivity classes that use a JDBC-ODBC bridge driver to
connect to the database.

My advice is to use JDBC if Java is your programming language of choice.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.