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?

Never eat soggy waffles. They Nasty!

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!


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

NB:For more details, contact mikemayaka@yahoo.co.uk

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.