I have a client who needs to link his MS Access to his MySql. Since the MySql is on the same server as his web site, access is granted via localhost, username, password..... no problem. Odbc works fine linking on the same server as MySql, but when attempts at linking the MS Access via odbc are made from a remote location, access is denied due to an unrecognized host IP address.
Since the connection is being made via a dial-up the last digits of the IP address are not static, and permission is denied to access the mysql db.
I did find a reference to using a % in place of the last digits of the IP address, but can't seem to figure out how... or where to use this method of granting permission to access mysql remotely.
Any suggestions are greatly appreciated.
