Reply to thread

Message: [QUOTE="Albretch, post: 576691"] Yeah! I figured! I just wanted to have more input from experienced people. So, and this is also info 'for the rest of us', in order to CREATE a new db in Access you will have to: 1._ know which version of Access you are working with 2._ keep a blank (no tables, queries, . . .) copy of an ".mdb" file for this version 3._ know which directory do you want the 'new' DB in 4._ transfer the blank copy to this dir 5._ rename the '.mdb' file to the name of the 'created' DB 6._ define the DSN "on the fly" by passing all driver conf. settings (ODBC configuration params in this case) inside the connect string: con = DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=C:/data/Access/<name>.mdb","<UsersId>","<password>"); I think this is not a big deal at all and works on the OS level, so probably MS Access drivers should do that on their own. Wouldn't you agree? Why don't they? [/QUOTE]