Table Updated with SQL Queries in Red in Client Windows but work ok in designer

[gilles.levesque]

Hello,
I have few table that are filled using SQL Queries. Thoses Table are working in Designer, but in the Client windows they are showing in Red. Any idea why?

[pturmel]

That’s likely a lack of the necessary security permissions. Go to project properties in the designer, find the security permissions, and turn on “Legacy Database Access”.

Or better, switch to Named Queries.

[JordanCClark]

Check the permissions in the project properties. You need Legacy Database Access checked.

EDIT: Phil beat me to it.

[gilles.levesque]

That Works Thanks!