FORGEBOX Enterprise 🚀 - Take your ColdFusion (CFML) Development to Modern Times! Learn More...


v0.8.3 Public


cfmlbadges cfmlbadges cfmlbadges

Connect to MS Access databases easily with the UCanAccess JDBC driver which supports MS Access files from 2000 through 2016.


via Forgebox Provider

  1. In your Lucee (Server) Administrator, go to the Extension > Providers page and add as a New Extension Provider if not already present
  2. Go to Extension > Applications and look for UCanAccess in the "Not installed" section
  3. Click the extension and install

Manual Installation

  1. Download the the lucee-ucanaccess.lex file
  2. In your Lucee Administrator, go to the Extension > Applications page
  3. Under "Upload new extension", select the lex file and click "Upload"


The main "trick" to using the driver is configuring your datasource.

  1. The classpath should be net.ucanaccess.jdbc.UcanaccessDriver
  2. The connection string should start with jdbc:ucanaccess: ///
  3. The rest of the connection string should be your full MS Access file path: C:\Users\me\my\AccessDatabase.accdb
msAccessDB = {
   class: "net.ucanaccess.jdbc.UcanaccessDriver",
   connectionString: "jdbc:ucanaccess:  ///C:\Users\me\my\AccessDatabase.accdb"


  • â�Œ Get it working
  • â�Œ Test various datasource options - e.g. connectionLimit, username, password
  • â�Œ Document various connection string options

The Good News

For all have sinned, and come short of the glory of God (Romans 3:23)

But God commendeth his love toward us, in that, while we were yet sinners, Christ died for us. (Romans 5:8)

That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. (Romans 10:9)


Copyright 2019 (and on) - Michael Born

Here are all the versions for this package. Please note that you can leverage CommandBox package versioning to install any package you like. Please refer to our managing package version guide for more information.

Version Created Last Update Published By Stable Actions
0.8.3 Sep 04 2019 03:33 PM Sep 04 2019 03:33 PM


No collaborators yet.
  • Jul 11 2019 08:35 AM
  • Sep 04 2019 03:33 PM
  • 155
  • 98
  • 47