aspose file tools
The moose likes JDBC and the fly likes How to create MSAccess file(.mdb) using java Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "How to create MSAccess file(.mdb) using java" Watch "How to create MSAccess file(.mdb) using java" New topic
Author

How to create MSAccess file(.mdb) using java

Soumayajit Hazra
Greenhorn

Joined: Nov 13, 2006
Posts: 8
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 26168
    
  66

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Wei Dai
Ranch Hand

Joined: Jun 22, 2005
Posts: 81
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
Marshal

Joined: Mar 22, 2005
Posts: 35232
    
    7
The Jackcess library provides a pure-Java way to create, read and write MDB files in Access 2000 format.


Android appsImageJ pluginsJava web charts
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to create MSAccess file(.mdb) using java
 
Similar Threads
MDB file creation
Create directories (MDB or servlet)
create .mdb file through command
MS ACCESS DSN less Connection
how to create .mdb file?