aspose file tools*
The moose likes JDBC and the fly likes MDB file creation Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MDB file creation" Watch "MDB file creation" New topic
Author

MDB file creation

Prem Shankar
Greenhorn

Joined: Jul 28, 2003
Posts: 21
Hi,
how to create an MDB file, with a table struct & records inserted in it?
Regards,
prem.
Mr. C Lamont Gilbert
Ranch Hand

Joined: Oct 05, 2001
Posts: 1170

Forgetaboutit.
MS simply chooses not to allow this. The best way is probably to create a visual Basic program and use JNI to connect to it. In essence creating a new driver.
The tables are easy though once you have a datasource or database file. Its creating the file thats impossible.

Alternatly I found this info somewhere I cant remember
There is an exe file named odbcconf.exe under \Winnt\System32\
All you need to do is put the following statement in the batch file and run the batch file using Runtime.getRuntime().exec("batch file name");
ODBCCONF.exe CONFIGDSN "Microsoft Access Driver (*.mdb)" DSN=xyz
xyz as DSN name.
leo donahue
Ranch Hand

Joined: Apr 17, 2003
Posts: 327
Originally posted by CL Gilbert:
Forgetaboutit.
MS simply chooses not to allow this. The best way is probably to create a visual Basic program and use JNI to connect to it. In essence creating a new driver.
The tables are easy though once you have a datasource or database file. Its creating the file thats impossible.

Huh??
Have a gander at this support document from Microsoft about creating an MDB file using ADOX


Thanks, leo
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MDB file creation