# Table disconnected in Live but in Ignition Design connected

**URL:** <https://forum.inductiveautomation.com/t/table-disconnected-in-live-but-in-ignition-design-connected/17665>\
**Category:** Ignition\
**Created:** [April 11, 2018, 12:56am UTC](https://forum.inductiveautomation.com/t/table-disconnected-in-live-but-in-ignition-design-connected/17665 "2018-04-11T00:56:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![trishhiyah](https://avatars.discourse-cdn.com/v4/letter/t/9fc29f/32.png) [@trishhiyah](https://forum.inductiveautomation.com/u/trishhiyah)\
**Post date:** [April 11, 2018, 12:56am UTC](https://forum.inductiveautomation.com/t/table-disconnected-in-live-but-in-ignition-design-connected/17665/1 "2018-04-11T00:56:47Z")

</div>

Hi I have encountered this issue, in Project it has red disconnected db in table.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/b3e41f8787034e753016d43a6479c7684b63648b.png)

But in Ignition design it is connected.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/3944c8a64d1961a9eedca806d2d9e9fdefb465d5.png)

---

<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:** [April 11, 2018, 12:33pm UTC](https://forum.inductiveautomation.com/t/table-disconnected-in-live-but-in-ignition-design-connected/17665/2 "2018-04-11T12:33:15Z")

</div>

Check in your project properties – you probably need to enable legacy queries.

---

<div class="post-metadata">

**Author:** ![martinel37461](https://avatars.discourse-cdn.com/v4/letter/m/4da419/32.png) [@martinel37461](https://forum.inductiveautomation.com/u/martinel37461)\
**Post date:** [April 11, 2018, 12:35pm UTC](https://forum.inductiveautomation.com/t/table-disconnected-in-live-but-in-ignition-design-connected/17665/3 "2018-04-11T12:35:27Z")

</div>

We encountered the same problem and found two solutions in our environment.  
Solution A: Change from SQL to a NamedQuery (my preference)  
Solution B: Change the “Legacy Database Access” setting in:  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project \> Properties \> Permissions

Hopefully one of those will work for you.