Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MDB file creation

 
Prem Shankar
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
how to create an MDB file, with a table struct & records inserted in it?
Regards,
prem.
 
Mr. C Lamont Gilbert
Ranch Hand
Posts: 1170
Eclipse IDE Hibernate Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 327
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic