Displaying query info onto table

I am displaying a query table info on a simple table and in the designer it shows its working and displays but in the vision client it does not show anything other then an error
Table designer
Table Vision

Any ideas?

Project Properties -> Client -> Permissions -> Legacy Database Access needs to be checked on.

Better solution would be to convert this to a named query and it will work without opening the security hole that is Legacy Database Access.