Microsoft Access Connector

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!