'ODBC--call failed - MSAccess linked table to mysql view
I have a MS Access front end database linked to tables and views on remote mysql database. It's in use for many months. Since yesterday when trying to open tables linked to views MS Access is raising the error "ODBC--call failed". The tables linked to remote tables are working normally. The views on the remote database are working normally in phpMyAdmin and HeidiSQL. I tried to import a view into local table in MS Access and it works, creating the local table with the data which is visible in the phpMyAdmin and HeidiSQL. The issue is the same on several PC in different physical locations. Any suggestions why there will be problems only with the tables linked to the remote views?
Solution 1:[1]
Confirm from the hosting company, if there is a change in connection strings required to access database on your account, or check the server where mysql/phpmyadmin is installed for changes.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Sola Oshinowo |