MsAccess using MySQL Views - Poss Fix..

[David Boccabella]

Hi Folks.

I was trying to find out why a view was not working on our server. Basically only some of the fields were being returned - those what were from the first table.. Not the joined table.

Whislt trying to generate a reports to the MySQL team (really great guy's) I noticed that it WAS working my local machine.

Both machines were using the same version of Ms-Access, MySQL, and MyODBC (3.51.12)

However I notives that the server copy of MyODBC3.dll was larger and older than my local one.

I copied that version up to the server and the views worked.

Here is the link

http://www.cvsol.com/public/myodbc3.zip

Now - I must have downlaoded this from somewhere in my desperation so thanks to whoever wrote this version.

Lets see it it fixed the issue for others and enable a very useful part of MySQL.

Take Care

David Boccabella
Senior Developer
Corporate Village Solutions
www.cvsol.com