Ignition and Access DB

Dear All,
we are struggling to communicate between Ignition and AccessDB.
image
we already checked the path. all files exists and can be accessed through local machine
giving this error.
Appreciate all help...a

All database operations are conducted from the gateway. The files must be on the gateway, in a folder accessible to the gateway background service. (UNC Paths are good choices, but the gateway service must be running under an account with suitable privileges. The default LOCAL_SYSTEM won't have such privileges.)

will try.. thank you..

locally it is communicating, but AccessDB is on another machine and
ignition is on another machine, and we are using UcanAccess driver 5.0.1,


any another way to write the connection strings...

I haven't used Access in many years. In all cases in the last 20 years, I've helped client migrate away from Access to an actual database technology. So I don't know anything about UcanAccess.

You should migrate away from Access.

1 Like

Do you mean if you put the access dB on the ignition gateway and change the path in the connection to the local address, it works?
If so, have you changed the service account that the ignition service is running under, like Phil mentioned?