This content has been marked as final. Show 3 replies
This isn't a JavaFX question; you should file it either in the Java Programming forum or (probably better) the Java Database Connectivity (JDBC) forum. A list of OTN Java forums is at https://forums.oracle.com/forums/category.jspa?categoryID=285
You'll likely need more details than "doesn't work", too... (what errors are you getting and when, etc). But again, this is the wrong forum.
You need to do the following:
Register your database using the ODBC control panel in Windows. There you can couple a name (myDB for example) to your database (accdb/mdb file).
In Java, all you need to do then is the following:
to get a connection.
Connection conn = DriverManager.getConnection("jdbc:odbc:myDB")
Note the following: you need to use a compatible JVM. That is: if Access is 32-bit, you need a 32-bit JVM as well. Also, if Windows is 64-bit and Access is 32-bit, you need to use C\windows\sysWOW64\odbcad32.exe instead of the control panel.