I am trying to create tables linked to a Mysql database
in MS Access. I get the widow to select a Data Source.
I click on the (system) DSN I created (and tested ok)
for my Mysql database, and click ok. The Database
Source selection window disappears, but no widow
showing the Mysql tables ever appears. No error
message.
Windows-2000-sp2 / Access-2000-sp3 / Mysql-5.0 /
mysql-connector-odbc-3.51.12
I found some old postings by others with this problem
but no answers.
Please help. If I can't fix this I will have to return to the
world of Access and Visual Basic. Death would be
preferable. :-)

Yes, the DSN was created from the DBC Administrator tool.
I can access the database ok using DBC from a Python
script that uses the DBC library so seems like DBC
is working, and the problem is with Access or some
Access/MDBC problem.

When I originally installed Mysql I chose utf8 as default
character set. Thinking that might be the problem, I re-
installed Mysql and Mysql-odbc using all the default install
options and then created a new database and dsn. But
Access still refuses to show the database objects select
dialog after I close the DBC DSN Select dialog when I
try to link to the mysql tables.

Any ideas?

"Jose Miguel Serrano" <jmserrano (AT) ain (DOT) eswrote in message news:438D8CF2.1090406 (AT) ain (DOT) esHi Stuart:

First, don't worry about return to Access + V. Basic. We are a hundred
thousand, -or more perhaps- people that works with similar solutions,
and the experience is very good.

About your problem, did you try create DSN directly from Control
panel->system tools->DBC?. If the answer is not, try please, that
perhaps is the problem.

Regards,

Josemi

Stuart escribio:
>
>I am trying to create tables linked to a Mysql database
>in MS Access. I get the widow to select a Data Source.
>I click on the (system) DSN I created (and tested ok)
>for my Mysql database, and click ok. The Database
>Source selection window disappears, but no widow
>showing the Mysql tables ever appears. No error
>message.
>
>Windows-2000-sp2 / Access-2000-sp3 / Mysql-5.0 /
>mysql-connector-odbc-3.51.12
>
>I found some old postings by others with this problem
>but no answers.
>
>Please help. If I can't fix this I will have to return to the
>world of Access and Visual Basic. Death would be
>preferable. :-)