Bug #11291 'VIEWS' not working while connecting to MySQL in Linux from MS Access ODBC

Description:
I am running Windows 2003 Access, MyODBC 3.51.11 on PC to connect to a database in MySQL 5.02 in Unix. I can link tables from a MySQL database to Ms Access.

There are some 'view tables' in the MySQL database. When I look at them from Access and double click on those tables in Access, it shows the original tables not the views.

Thanks,
--Narges

How to repeat:
-create a view table in your database (in MySQl 5.02 server in Linux).

      Example :
                 create view item_view as (select * from items where unit='GSE')

-Make a connection via MyODBC 3.51.11 in MS Access to the server and try to open
the view table (item_view).

- You would  see the original table (items) and not the view table (item_view).

Suggested fix:
Apparently the SQLs written in MySQL server for the view tables can not be translated/run in MS Access connected to the MySQL server via MyODBC.

I was not able to reproduce the bug on mysql 5.0.7. Could you please upgrade your version of mysql ?

Dear Vasily Kishkin,

Do you think it is a problem with MySQL server. I checked the view tables by connecting to the server via JDBC in DBvisualizer and the views worked. So I 
thought there is some thing wrong with ODBC and etc.
Let me know if you still think that we have to upgrade our server.

Thanks,
--Narges

I would like to say the bug might be fixed in 5.0.7. Could you please set up new version of mysql server and try to reproduce the bug ?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.