How to create MSAccess file(.mdb) using java

[Soumayajit Hazra]

I am trying to create access database at runtime. For that purpose we need to create .mdb file runtime. How to do this? please help...

[Jeanne Boyarsky]

I don't think it is possible to do this purely in Java. You could call an operating system script using Runtime.exec() and then use a batch/shell script.

[Wei Dai]

Free solution: prepare a blank mdb file, then copy it as the destination file, then use dsn-less jdbc url to access it.
Commercial solution: use the CREATE DATABASE sql at http://www.hxtt.com/access/sqlsyntax.html#createdatabase .

[Ulf Dittmer]

The Jackcess library provides a pure-Java way to create, read and write MDB files in Access 2000 format.