I’m trying to create a database connection to an Access 2010 data base and found this on the site from Mike BR: 1. Download ucanaccess version 4.0.4 from the following:
https://sourceforge.net/projects/ucanaccess/files/
- Extract the zip files to a directory you will be using (i.e. MyDocuments)
- extract ucanaccess-4.0.4.jar using WINRAR or https://extract.me/ (this creates a “net” and “META-INF” directory)
- Create a new Database Driver in Ignition from the Configure menu
Name: MSAccessDB
add the following JAR files
C:\Users\xxxx\Documents\AccessDB\UCanAccess-4.0.4-bin\lib\commons-lang-2.6.jar;
C:\Users\xxxx\Documents\AccessDB\UCanAccess-4.0.4-bin\lib\commons-logging-1.1.3.jar;
C:\Users\xxxx\Documents\AccessDB\UCanAccess-4.0.4-bin\lib\hsqldb.jar;
C:\Users\xxxx\Documents\AccessDB\UCanAccess-4.0.4-bin\lib\jackcess-2.1.11.jar;
C:\Users\xxxx\Documents\AccessDB\UCanAccess-4.0.4-bin\ucanaccess-4.0.4.jar;
Classname: net.ucanaccess.jdbc.UcanaccessDriver
when I try to add the jar files it says C:\fakepath\commons-lang-2.6.jar!!
the files are located in C:\Users\xx\Downloads\UCanAccess-4.0.4-bin\lib
Any insight would be appreciated
If there is a better way of doing this I would appreciate a point in the right direction