# Ignition and Access DB

**URL:** <https://forum.inductiveautomation.com/t/ignition-and-access-db/95894>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [September 12, 2024, 12:39pm UTC](https://forum.inductiveautomation.com/t/ignition-and-access-db/95894 "2024-09-12T12:39:00Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aditya\_Nakate2](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@Aditya\_Nakate2](https://forum.inductiveautomation.com/u/Aditya_Nakate2)\
**Post date:** [September 12, 2024, 12:39pm UTC](https://forum.inductiveautomation.com/t/ignition-and-access-db/95894/1 "2024-09-12T12:39:00Z")

</div>

Dear All,  
we are struggling to communicate between Ignition and AccessDB.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/3/a378935bd4b2ba0bce30c7bc49b3b4f3797b6547.png)  
we already checked the path. all files exists and can be accessed through local machine  
giving this error.  
Appreciate all help...a

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 12, 2024, 12:53pm UTC](https://forum.inductiveautomation.com/t/ignition-and-access-db/95894/2 "2024-09-12T12:53:16Z")

</div>

> [@Aditya\_Nakate2](#):
>
> through local machine

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.)

---

<div class="post-metadata">

**Author:** ![Aditya\_Nakate2](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@Aditya\_Nakate2](https://forum.inductiveautomation.com/u/Aditya_Nakate2)\
**Post date:** [September 13, 2024, 4:20am UTC](https://forum.inductiveautomation.com/t/ignition-and-access-db/95894/3 "2024-09-13T04:20:35Z")

</div>

will try.. thank you..

---

<div class="post-metadata">

**Author:** ![Aditya\_Nakate2](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@Aditya\_Nakate2](https://forum.inductiveautomation.com/u/Aditya_Nakate2)\
**Post date:** [September 13, 2024, 6:52am UTC](https://forum.inductiveautomation.com/t/ignition-and-access-db/95894/4 "2024-09-13T06:52:52Z")

</div>

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,

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/6/56d85c985fd3b9e2f3a6cadb32564456a5d4d3b5.png)  
any another way to write the connection strings...

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 13, 2024, 11:23am UTC](https://forum.inductiveautomation.com/t/ignition-and-access-db/95894/5 "2024-09-13T11:23:03Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [September 13, 2024, 1:31pm UTC](https://forum.inductiveautomation.com/t/ignition-and-access-db/95894/6 "2024-09-13T13:31:36Z")

</div>

> [@Aditya\_Nakate2](#):
>
> locally it is communicating

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?

> [@pturmel](#):
>
> 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.