MySQL ODBC Connector - cant link tables in Access

Author

cant link tables in Access

Stuart

2005-11-29, 8:24 pm

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? unsu...sie.nctu.edu.tw

José Miguel Serrano

2005-11-30, 7:23 am

-------------- 01060101040904060905
0209
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable

Hi Stuart:

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

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

Regards,

Josemi

--------------------------

Stuart escribi=C3=B3:

>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=20
>Source selection window disappears, but no widow=20
>showing the Mysql tables ever appears. No error=20
>message.=20
>
>Windows-2000-sp2 / Access-2000-sp3 / Mysql-5.0 /=20
>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=20
>preferable. :-)
>
>
> =20
>

-------------- 01060101040904060905
0209--

Stuart

2005-11-30, 8:23 pm

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@ain.es> wrote in message news:438D8CF2.1090406@ain.es...> Hi Stuart:[color=darkre
d]
>
> 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:
>

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc? unsu...sie.nctu.edu.tw

Sponsored Links