I have a requirement to link directly to a table in MySQL Remote database.
I have acquired a MySQL ODBC Driver for Windows ODBC-3.51.11-1
The MySQL Database can only be accessed via an SSH connection and I can do that and talk to the required tables in a command window.
The procedure against the table is a simple append.
However, I ideally want to be able to link to and see this table from inside access.
Does anyone have any ideas how this can be done
If it can be done?