Ucanaccess 4.0.3 as previous versions do not close connection to Access database. After database reader o writer node is used it is necessary to close KNIME to compact Access database. Could it be fixed?
with the current framework KNIME caches the database connection for performance reasons. To connection is only closed once KNIME is shutdown. This might change with the update of the DB framework on which we are working right now. There we plan that the user can also close the connection by simply resetting the connector node.
Thank you, Tobias. I see 2 reasonable solution: add close connection node or time out connection. Node reset is not feasible solution as far data result could be necessary for father review.
thanks for the feedback. We will consider these options for the new framework.