# TPS TryInsert Access Denied

**URL:** <https://clarionhub.com/t/tps-tryinsert-access-denied/8851>\
**Category:** questions\
**Tags:** sqlite, tps\
**Created:** [December 12, 2025, 3:02pm UTC](https://clarionhub.com/t/tps-tryinsert-access-denied/8851 "2025-12-12T15:02:15Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![greenslk](https://clarionhub.com/letter_avatar_proxy/v4/letter/g/7cd45c/32.png) [@greenslk](https://clarionhub.com/u/greenslk)\
**Post date:** [December 12, 2025, 3:02pm UTC](https://clarionhub.com/t/tps-tryinsert-access-denied/8851/1 "2025-12-12T15:02:15Z")

</div>

Using a process template reading an SQLite2 table and writing to TPS (C:\Users\Public\Documents\myApp\data\v3DailyMetrics.tps) fails with Access Denied

The open is successful but the TryInsert throws an error

|\*\*\* dbState:|Access:v3DailyMetrics.TryOpen() - 0.  
|\*\*\* dbError|Access:v3DailyMetrics.TryInsert() - 5.Access Denied

I've checked the DCT (which is being used by 3 other apps and they work just fine)

I've checked the Individual File controls in the app and it's the same as the other apps.

Any thoughts?

---

<div class="post-metadata">

**Author:** ![jslarve](https://clarionhub.com/letter_avatar_proxy/v4/letter/j/e480ec/32.png) [@jslarve](https://clarionhub.com/u/jslarve)\
**Post date:** [December 12, 2025, 3:04pm UTC](https://clarionhub.com/t/tps-tryinsert-access-denied/8851/2 "2025-12-12T15:04:48Z")

</div>

What do you get if you call STATUS(YourFile) ?

That will tell you your open mode.

---

<div class="post-metadata">

**Author:** ![CarlBarnes](https://clarionhub.com/user_avatar/clarionhub.com/carlbarnes/32/1859_2.png) [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\
**Post date:** [December 12, 2025, 4:06pm UTC](https://clarionhub.com/t/tps-tryinsert-access-denied/8851/3 "2025-12-12T16:06:38Z")

</div>

> [@jslarve](#):
>
> STATUS(YourFile)

Further … the [Open Mode](http://clarion.help/doku.php?id=open_open_a_data_structure_.htm) may be Read Only which an ADD would be denied.

[Help on STATUS](http://clarion.help/doku.php?id=status_return_file_status_.htm) example code notes `IF STATUS(YourFile) % 16 = 0 !Opened Read-Only?`

Your have to look in the DCT to see the default Open Mode. I think if you have it set to Deny All and try to open it on more than one thread, then it gets opened Read Only.

---

<div class="post-metadata">

**Author:** ![greenslk](https://clarionhub.com/letter_avatar_proxy/v4/letter/g/7cd45c/32.png) [@greenslk](https://clarionhub.com/u/greenslk)\
**Post date:** [December 12, 2025, 4:20pm UTC](https://clarionhub.com/t/tps-tryinsert-access-denied/8851/4 "2025-12-12T16:20:53Z")

</div>

v3DailyMetrics:Status 64

Tried to force it to OPEN ReadWrite (2) but still shows 64

---

<div class="post-metadata">

**Author:** ![Rick\_UpperPark](https://clarionhub.com/user_avatar/clarionhub.com/rick_upperpark/32/346_2.png) [@Rick\_UpperPark](https://clarionhub.com/u/Rick_UpperPark)\
**Post date:** [December 12, 2025, 4:26pm UTC](https://clarionhub.com/t/tps-tryinsert-access-denied/8851/5 "2025-12-12T16:26:40Z")

</div>

64 Decimal is Readonly+Deny None.  
Try putting OPEN(v3DailyMetrics, ReadWrite+DenyNone) 042h and testing errorcode() and status() afterwards.  
Also, trace out v3DailyMetrics{Prop:Name} and make sure the file it is opening is really where you think it is.

---

<div class="post-metadata">

**Author:** ![greenslk](https://clarionhub.com/letter_avatar_proxy/v4/letter/g/7cd45c/32.png) [@greenslk](https://clarionhub.com/u/greenslk)\
**Post date:** [December 12, 2025, 4:43pm UTC](https://clarionhub.com/t/tps-tryinsert-access-denied/8851/6 "2025-12-12T16:43:04Z")

</div>

Thx All!

found the culprit - deep embedded code in global … inherited code ☹

```
**SHARE(refFile, ReadOnly+DenyNone)**

```