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

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?

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.

1 Like

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

EDIT: Phil beat me to it. :wink:

That Works Thanks!