Creating *.mdb file

[47pirates]

Is it possible to create a microsoft access database (mdb) file through a java program?
and how to register the thus created mdb file to ODBC center?
thanx in advance

[amrita111]

yes.you can create *.mdb using java..

[dononelson]

Check out http://jackcess.sourceforge.net/ - that should get you on your way.

[Ezzaral]

The real question ought to be should you create an mdb with Java and I would answer: Only if you absolutely have to due to other constraints on the project.

If you can use any other database, do so. For a file-based database, H2 is great.

[mKorbel]

@ Ezzaral

<OT>I tried that, excelent but there exist another list for inMemory DB's http://en.wikipedia.org/wiki/Embedded_database<OT>

to OP

Jackcess is a pure Java library for reading from and writing to MS Access databases (currently supporting versions 2000-2007).

Is it possible to create a microsoft access database (mdb) file through a java program

yes, you can search a prerequisities for that on www.microsoft.com be sure that on this PC must be instaled (Minimum) MsAccess

pack empty *.mdb file into Java Package (or distribute that your compiled Jar File + empty MsAccess Database) on Runtime create new Tables etc

and how to register the thus created mdb file to ODBC center

manually or search script for that on www.microsoft.com