linking mysql tables (odbc) from ms-access: "Could not find installable ISAM"

[tele]

I have been connecting to mysql tables from access trough odbc [MySQL]
[ODBC 3.51 Driver] and everything is ok.

Then I intended linking mysql tables from ms-access > file>get
external data > ODBC>user dsn I got “ODBC call failed” error.

Later when I intended from ms-access VBA I got a "Could not find
installable ISAM".

Then I found http://support.microsoft.com/kb/209805/EN-US/ article
attributing error cause to unregistered dll, I have followed 2 recipes
but nothing happened ?.

The article above says: ISAM drivers are used by Access to update file
formats other than its own. If the path of the ISAM driver in your
Windows Registry is not valid, or if the ISAM driver does not exist,
the problem may occur.

Well my question is what exactly dll access is asking for (name) and
how to register it in order that access find it the right way or any
other valuable information to solve this problem.

Thank you in advance

[Tony Toews]

On Wed, 1 Dec 2010 08:11:55 -0800 (PST), tele
<telepro...@gmail.com> wrote:

>I have been connecting to mysql tables from access trough odbc [MySQL]
>[ODBC 3.51 Driver] and everything is ok.
>
>Then I intended linking mysql tables from ms-access > file>get
>external data > ODBC>user dsn I got “ODBC call failed” error.

I much prefer DSN-Less connections as it is one less thing for someone
to have to configure and one less thing for the users to screw up.
This is also better for Citrix/TS farms where each individual system
would have to have a DSN created and maintained.

Using DSN-Less Connections
http://www.accessmvp.com/djsteele/DSNLessLinks.html
ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafast/GetFile.aspx?file=ODBCTutor01.htm&Article=true
HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875
ODBC DSN Less
http://www.carlprothman.net/Default.aspx?tabid=81
Relink ODBC tables from code
http://www.mvps.org/access/tables/tbl0010.htm

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/