Member Avatar for 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

  • 5 Contributors
  • 4 Replies
  • 245 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by mKorbel
Member Avatar for amrita111

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

Member Avatar for 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.

Member Avatar for 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

Edited by mKorbel because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.