MDB file creation

[Prem Shankar]

Hi,
how to create an MDB file, with a table struct & records inserted in it?
Regards,
prem.

[Mr. C Lamont 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.

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]

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