# Creating a JDBC Driver for microsoft access 2010 in ignition 7.9.10

**URL:** <https://forum.inductiveautomation.com/t/creating-a-jdbc-driver-for-microsoft-access-2010-in-ignition-7-9-10/23961>\
**Category:** Ignition\
**Created:** [April 9, 2019, 4:29pm UTC](https://forum.inductiveautomation.com/t/creating-a-jdbc-driver-for-microsoft-access-2010-in-ignition-7-9-10/23961 "2019-04-09T16:29:32Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Charles.locascio](https://avatars.discourse-cdn.com/v4/letter/c/c6cbf5/32.png) [@Charles.locascio](https://forum.inductiveautomation.com/u/Charles.locascio)\
**Post date:** [April 9, 2019, 4:29pm UTC](https://forum.inductiveautomation.com/t/creating-a-jdbc-driver-for-microsoft-access-2010-in-ignition-7-9-10/23961/1 "2019-04-09T16:29:32Z")

</div>

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/](https://sourceforge.net/projects/ucanaccess/files/)

1. Extract the zip files to a directory you will be using (i.e. MyDocuments)
2. extract ucanaccess-4.0.4.jar using WINRAR or [https://extract.me/](https://extract.me/) (this creates a “net” and “META-INF” directory)
3. 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