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 | |
JDBC Url | jdbc:ucanaccess://path.mdb |
Driver folder | <Hop Installation>/plugins/databases/access/lib/ |