<div>
Did it ever work? &nbsp;Not all databases support all functions in ODBC.
</div>


Did it ever work?  Not all databases support all functions in ODBC.

<div>
just realised i made a huge mistake, my problem
</div>


just realised i made a huge mistake, my problem

<div>
Pointed me in the right direction, very little needed
</div>


Pointed me in the right direction, very little needed

<div>
<div class="content wysiwyg-content">
I am using ODBC to connect mysql tables to an MS ACCESS front end. (2010)<br />
<br />
all working fine and now I am getting ODBC -- call failed.<br />
<br />
The strange thing is that I can double click on a table and the rows are displayed.<br />
<br />
Yet when I click on linked table manager I am getting ODBC -- call failed.<br />
<br />
Any Ideas, I suspect it is on the server side as all PC's connected are given the same error
</div>
</div>


I am using ODBC to connect mysql tables to an MS ACCESS front end. (2010)

all working fine and now I am getting ODBC -- call failed.

The strange thing is that I can double click on a table and the rows are displayed.

Yet when I click on linked table manager I am getting ODBC -- call failed.

Any Ideas, I suspect it is on the server side as all PC's connected are given the same error

ODBC Problem

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.