I have a basic workflow where I am attempting to write a 3.5M rows into a freshly created DB table in Microsoft Access. The nodes are: [image] The config at the Access Connector Node: [image] The config at the DB Table Creator Node: [image] The config at the DB Writer Node: [image] In File Explorer, the file looks like it’s being worked on: [image] I’ve already gone through the UCanAccess process, but same problem there. Back to using the driver per above config snapshot. I’m frequently working with KNIME SQLite databases in KNIME with similar data sizes, but never really see anything get stuck like this at 99%.

Hello @qdmt , perhaps you are hitting some Microsoft Access DB limitation: Access specifications - Microsoft Support Find limits and specifications for Access 2016 database files and objects, such as the maximum file size or the maximum number of fields in a table. Br, Ivan

DB Writer to Access DB Hangs at 99%

KNIME Analytics Platform

ipazin August 29, 2023, 8:29am 3

Hello @qdmt,

perhaps you are hitting some Microsoft Access DB limitation:

Br,
Ivan

4 Likes

Access Connector: Java heap space