On Feb 15, 3:43 pm, "Jayhawk" <mccal...@gmail.comwrote:
Hello,
I am trying to use a MS Access front end application to link to data
tables stored in MySQL Server. I am running MySQL 5.0 Community
Server, MySQL Connector/ODBC 3.51, and MS Access 2003. I have set up
a test database and table in MySQL, but the problem comes when trying
to link to this table through Access. From the Link Tables menu
option, I choose ODBC Databases, but no "Select Data Source" dialogue
window will pop up. All that happens is that the Link Tables window
disappears. Has anyone encountered this problem? Your help is
appreciated.
-Shane
I don't remember the exact symptoms but I have seen cases where MySQL
ODBC 3.51 does not work on some machines, presumably due to an
incompatibility with some other piece of software. I've never had it
fail on my machines, but it did fail consistently on some client's
workstations.
The on-site IT person for one of my customers even tried to pin it
down by starting with a vanilla OS image and installing their standard
software load one application at a time. Unfortunately they never
found the answer because after they installed all of their standard
applications individually MySQL ODBC 3.51 still worked, but when they
ghosted their departmental standard image onto the same machine it
wouldn't fly. They wound up using the previous version of MySQL ODBC
(v2.50) instead. However, I'm not sure that you can use v2.50 of the
MySQL ODBC driver with MySQL 5.x.