Troubleshooting connecting to MySQL in VBA
Lesson 17 Chapter 5
To connect to MySQL database we need to have the MySQL Connector/ODBC driver installed.
Virtual Form control is a 32-bit application, so you need to install the 32-bit version of the MySQL driver.
If you have 64-bit Office version you need to install both 32-bit & 64-bit versions of the MySQL driver so that Virtual Form control (32-bit) & VBA (64-bit) can connect to MySQL
You can get the download links and the sample connections strings from the Resources section on Virtual Forms webpage.
Here is the direct link: