I am trying to find the right approach to refreshing Linked tables that are from a MYSql backend from with Access/VBA. I have seen code to refresh SQL and Access tables and when I try to converrt this code to use a MY Sql table I am unsuccessful.
All I want to do is on open of my database it refreshes all linked tables and not just the Access tables, I have gotten the error 91 in some cases.
I want to be able to use a scheduling program to run my daily reports during the night and this problem is preventing me from accomplishing this task. There must be a simple bit of code that will accomplish this task.
I have searched the internet high and low with out success. I have tried the MYODBC connection string, I have looked at Microsoft website - the code there is for SQL and not MYSql.
Any an all suggestions are greatly appreciated. I am under a deadline and would like to tell my client I have found the solution. If it was possible I would double the awarded points to the person who has a workable solution.