Is there a standard method of connecting a Java application to an MS Access database that does not involve creating an ODBC data source? Basically, a driver that allows you specify the file path as the connection string and run queries against it directly.
2) If you are running a 32-bit version of Office, you will likely get the following error when you try to install it: "You cannot install the 64-bit version of Office 2010 because you have 32-bit Office products installed.". At this point, you must decide whether or not to uninstall the Office. Newer versions of Office, such as 2010, contain both both 32-bit and 64-bit versions on the DVD. In this case, you would first uninstall the 32-bit version of Office. Restart. Then ignore the auto-run on the DVD, and open the setup executable in the x64 directory. If you do not have access to a 64-bit version of Office, then you will unable to run the 32-bit version alongside the 64-bit Engine.
3) The connection string must be updated as follows: