cant link tables in Access

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@m.gmane.org

Re: cant link tables in Access

--------------010601010409040609050209
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ó:

>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
>

--------------010601010409040609050209--

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" wrote in message news:438D8CF2.1090406@ain.es...> 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@m.gmane.org

Re: cant link tables in Access

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


Hello Stuart:

OK. I had answered you the last idea, because time ago, -I don't=20
remember, but about 2 years ago- I had tried create DSN from Access=20
while I was creating a link to MySQL database, and this kind problem had =

happened to me. The solution came when I created DSN from Control Panel.

We have in our enterprise your similar scenario, and all work fine. I=20
going to tell you the exactly configuration : Windows 2000 sp2 or=20
Windows XP + Access 2000 + MyODBC-3.51.11-2 + MySQL Server 4.1.12-Max.

I propose you at the first to try change MyODBC version. I have read=20
some problem, with your version in this list. Perhaps could be=20
interesting try with other computers, or if you have vmware or similar,=20
make tries in a virtual machine. Then you can isolate tries.

Please, tell us your experiences.

Best regards,

Josemi

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

Stuart escribió:

>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=20
>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=20
>Access still refuses to show the database objects select=20
>dialog after I close the ODBC DSN Select dialog when I=20
>try to link to the mysql tables.
>
>Any ideas????
>
> =20
>

--------------050508070209040300050709--