Re: cant link tables in Access

Yes, the DSN was created from the ODBC Administrator tool.
I can access the database ok using ODBC from a Python
script that uses the mx.ODBC library so seems like ODBC
is working, and the problem is with Access or some 
Access/Mysql-ODBC 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 ODBC DSN Select dialog when I 
try to link to the mysql tables.

Any ideas????

"Jose Miguel Serrano" <jmserrano@xxxxxx> wrote in message 
news:438D8CF2.1090406@xxxxxxxxx> Hi 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->ODBC?. 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. :-)




-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx