Hi everyone,
I used the control panel to set the odbc and link my application to a MYSQL database and it work well.
Now I'm about to create another application and want to make the linking through VBA.
My question is when do I create the connection ?
I guess it should be at the launch of the application.
Then if the connection is make at that moment, are the linked tables and views downloaded and available for all the queries and bound forms or do I need to recreate the connection everytime ?
Thanks in advance.
I used the control panel to set the odbc and link my application to a MYSQL database and it work well.
Now I'm about to create another application and want to make the linking through VBA.
My question is when do I create the connection ?
I guess it should be at the launch of the application.
Then if the connection is make at that moment, are the linked tables and views downloaded and available for all the queries and bound forms or do I need to recreate the connection everytime ?
Thanks in advance.