Ms Access Link To Mysql View

[violante]

Hi,

I'm using a ODBC Connection to link tables and views from mySQL DB.

With tables I have no problems, but when I link to a View and try to view the records i get a messagwe saying the is impossible to find the data.

I'm using MS ACCESS 2003 SP2

MySQL ODBC 3.51 Driver

Can someone help me?

[peterlaursen]

I think that this ODBC driver cannot handle views!

That is one reason why I personally use Open Office Base (that can connect with JDBC – and here VIEWs work fine) if I need printing facilities for instance.

Maybe MyODBC 5.04 will work with Views. It is supposed to! the README tells:

“The short term plan is to have C/ODBC v5 support all major features of the existing C/ODBC v3 driver as well as flagship MySQL-5.0 features including stored procedures and views.”

I do not know Access 2003, but I doubt that 2000 and 2002 will ever be able to understand VIEWs.

MyODBC 5.04 is an alpha. I tried 5.02 and that was not easy to install!

But looks like 5.04 is improved in this respect!

http://mysql.com/downloads/connector/odbc/5.0.html

[peterlaursen]

I just tried MyODBC 5.04 myself.

It installs without problems. But when I try to use it Open Office base neither Tables nor Views show up. And with Access 2000 an error msgbox 'Driver does not support the environmental attributes' (translated from Danish) pops up.

[violante]

peterlaursen wrote on Aug 1 2006, 10:14 PM:

It installs without problems.

Hi…

I unziped the folder and run install.bat, but it doesn't work.

I really don't understand the readme file 🙁

Could you help me?

[violante]

I did it, it was in fact verry easy 😮

But I can't even connect to the database, i get a message saying that the connection was canceled (translating from frenck system)

🙁

[Author]

Posts