Hi new to all this so forgive me if this does not make any sense.
I have created a view in MySQL using phpMyadmin on our web server. I can connect to the server via access 2016 using an ODBC connection and I can view any table but when I try and and open the view in access is gives me an ODBC connection error and only shows me the column headings.
Can anyone shed any light on this.
Cheers