Writing to an Access Database using Java...

[Fyrelion]

Hi,

I was wondering how you write to an Access Database using current Java versions. I've been looking pretty hard for awhile with a teacher and some friends, but so far we haven't come up with anything. Could you guys help me out?
Thx

Never eat soggy waffles. They Nasty!

[lohengrin332]

For most database systems, you can simply download a JDBC driver to connect to the Db with Java, but there aren't any free ones for Access. What I ended up having to do was create an ODBC datasource (with Windows), and use the JDBC-ODBC bridge to connect to that. I think the JDBC-ODBC bridge is included with the JDK package. Good luck!

David

[Mayaka]

Hi,
You can create an access datasource in Win2k as follows: Start->Control panel->Administrative tools->Data Sources(ODBC)->MS Access Database->System DSN->Add->Select MS Access Database Driver ->Finish->Enter datasource name->Select Database->Click ok
Mike.

NB:For more details, contact [e-mail]