Microsoft Access Connector

KNIME Extensions
,
1

Hi everyone,

I’m using the Microsoft Access Connector, specifically the DB Writer, to update my MS Access database. It works well when the database is on my local drive, but I encounter the error “Execute failed: UCAExc:::5.0.1” when the database is on a network drive.

Interestingly, when I select the driver for Microsoft Access v4.0.4 (deprecated) [ID: msaccess], it functions properly.

Does anyone have suggestions on how to resolve this issue?

Thank you!

2

Are you sure that the JDBC URL is formatted properly to find a file on a network drive? See below:

(Although I guess if the deprecated driver works OK, you’ve found a suitable workaround already?)

2 Likes
3

further research, I need to have full control rights for the folder not just read and write permissions.
The access connector is now working perfectly.
Thanks

2 Likes