I’ve recently taught mysef the fundamentals of Vaadin and Microsoft Access. I’ve gotten Vaadin to access a simple MySQL database without any problems. I’ve also created the real database in Access. My question is how do I get the two to work together? Is there a driver I can use to access the .accdb database itself, or is there a format I can convert to that is compatible with Vaadin but can also still be administered with Access? Thanks.
Hi,
basically Vaadin does not have much to do with this - the correct question is how to connect to MS Access from Java code. You might want to look at e.g.
http://www.selikoff.net/2011/07/26/connecting-to-ms-access-file-via-jdbc-in-64-bit-java/
which provides some info on the matter. In short what you need to do is to use the JDBC-ODBC bridge driver to be able to connect.
If you have to modify access db structure also. You should look
http://jackcess.sourceforge.net/