Hi, I’m just starting out on a first project. But I can’t seem to get my SQL queries to work in a project. My tables and bar charts work in the designer fine. But once it’s launched to say a windowed view the table becomes red and doesn’t connect. Like so:
Everything works in the designer, it’s the thin clients that aren’t working. Any ideas?
Check your project’s security properties – you may need to allow legacy queries. (As opposed to Named Queries, the “correct” way to access the database from the client going forward.)
2 Likes
oh, wow that was a quick reply… .and yup that was it!! Under Client I turned on “Legacy Database Access” and it worked.
Thank you very much!
1 Like
You posted this last year. “Check your project’s security properties – you may need to allow legacy queries. (As opposed to Named Queries, the “correct” way to access the database from the client going forward.)”
I have the same issue. I have spend almost an hour looking, and I can’t find where this allow legacy queries checkbox is located. Can you give me the exact location of where to find it.
Thanks.