I've connected to MySQL from Access 97 successfully. Usually what happens
after selecting the DSN is you are prompted for login information. I would
suggest upgrading your Windows 2000 to SP4 - I seem to recall there was an
issue with the MyODBC connector that required SP4.

"Stuart McGraw" <smcg4191zz@friizz.RimoovAllZZs.com> wrote in message
news:11p0rn7nkj86403@corp.supernews.com...
> I am having a problem creating Access tables linked to a
> Mysql database. I get the widow to select a Data Source,
> click on the (system) DSN I created (and tested ok), and
> click ok. The Database Source selection window disappears,
> but no window showing the Mysql tables ever appears nor
> does any kind of error message (typical Microsoft.)
> I can read the Mysql table using ODBC from a Python
> program, so Mysql and ODBC seem to be working, looks
> like Access is the one refusing to cooperate. Also, Access
> seems screwed up after this, often dieing with an access
> violation later on.
>
> Any sugesstion about how to trouble shoot this? I generated
> a odbc trace file, but I don't recognise anything in there as
> being a blatant error.
>
> Windows-2000-sp2 / Access-2000-sp3 / Mysql-5.0 /
> mysql-connector-odbc-3.51.12
>