# Cannot WRITE to MS Access Database

**URL:** <https://forum.inductiveautomation.com/t/cannot-write-to-ms-access-database/24987>\
**Category:** Ignition\
**Tags:** scripting\
**Created:** [May 14, 2019, 4:01pm UTC](https://forum.inductiveautomation.com/t/cannot-write-to-ms-access-database/24987 "2019-05-14T16:01:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![cmaynes](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmaynes/32/6852_2.png) [@cmaynes](https://forum.inductiveautomation.com/u/cmaynes)\
**Post date:** [May 14, 2019, 4:01pm UTC](https://forum.inductiveautomation.com/t/cannot-write-to-ms-access-database/24987/1 "2019-05-14T16:01:18Z")

</div>

I have an ms access database, following the steps [here](http://forum.inductiveautomation.com/t/ms-access-database-connection-with-ignition-7-8/11256/4), using UCanAccess as the driver.

Updates & inserts to this database do not work, but selects do.

The problem has been brought up multiple times, but no solutions are posted.

Can anyone help to resolve this?

---

<div class="post-metadata">

**Author:** ![Rendi.Yohanes](https://avatars.discourse-cdn.com/v4/letter/r/a183cd/32.png) [@Rendi.Yohanes](https://forum.inductiveautomation.com/u/Rendi.Yohanes)\
**Post date:** [May 15, 2019, 3:01pm UTC](https://forum.inductiveautomation.com/t/cannot-write-to-ms-access-database/24987/2 "2019-05-15T15:01:08Z")

</div>

maybe can you share the error details?

anyway, not sure if you have checked this, I had similar issue with MSSQL  
In recent Ignition version (7.8 or 7.9 can’t remember), they added a setting under “Project Properties”.

You need to allow permision for “Datasource Management” in order for a particular user to do database edit (updates, insertes, etc.)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4c8823c5fd3b0ddb1bdb3168d4787b6fa6deb34b.png)

---

<div class="post-metadata">

**Author:** ![cmaynes](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmaynes/32/6852_2.png) [@cmaynes](https://forum.inductiveautomation.com/u/cmaynes)\
**Post date:** [May 16, 2019, 6:55pm UTC](https://forum.inductiveautomation.com/t/cannot-write-to-ms-access-database/24987/3 "2019-05-16T18:55:25Z")

</div>

Hey @Rendi.Yohanes, thanks for your input.

There are no errors. Calling an update function when the access file is opened or when it is closed appears to work, because select queries following it return the updated values; however, closing and reopening the ms access file seems to wipe out any changes that were made using ucanaccess as the driver.

I have verified that there is not some weird permission issue for this ms access file, by using pyodbc to write to the file. pyodbc can successfully make changes to the file, but it is not available in Jython and I had to run it in Python 3 on my box.

Does anyone have suggestions on what to try next?

---

<div class="post-metadata">

**Author:** ![cmaynes](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmaynes/32/6852_2.png) [@cmaynes](https://forum.inductiveautomation.com/u/cmaynes)\
**Post date:** [May 20, 2019, 3:20pm UTC](https://forum.inductiveautomation.com/t/cannot-write-to-ms-access-database/24987/4 "2019-05-20T15:20:59Z")

</div>

Any movement on this?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [May 20, 2019, 3:26pm UTC](https://forum.inductiveautomation.com/t/cannot-write-to-ms-access-database/24987/5 "2019-05-20T15:26:42Z")

</div>

Try looking in the gateway logs for any loggers added by the JDBC driver - it’s possible it’s reporting some error condition. You can also try setting the `gateway.database.updates` logger to TRACE (warning, this will throw a _lot_ of events into the logs) to see the exact SQL queries being issued out of Ignition. You can then verify there’s not just some syntax error occurring on updates.

Ultimately, though, you’re pretty much on untreaded ground - we don’t guarantee support with other databases outside of basic JDBC driver compliance - it seems like it should work based on skimming their website, but tracking down the actual problem may be difficult.