Microsoft Access

When creating new database connection, specify the database path to the .mdb or .accdb file in database name field.

This database connection uses the UCanAccess driver which works well for reading with TableInput, DatabaseLookup, but it’s not great for writing. For writing it is better to use the Microsoft Access Output transformation.

Option Info

Type

Relational

Driver

Included

Version Included

5.0.1

Hop Dependencies

None

Documentation

Documentation Link

JDBC Url

jdbc:ucanaccess://path.mdb

Driver folder

<Hop Installation>/plugins/databases/access/lib/