Most Recommended Resources

These are some of our favorite tools or downloads that will be helpful. Some of them are FREE and some are paid.

Disclosure: Some of the links are affiliate links, and at no additional cost to you we will earn a small commission if you decide to make a purchase. We recommend you only purchase these products if you believe they will help you achieve your specific goals.

RECOMMENDED WEB HOSTING PROVIDERS:

MySQL:

MySQL Workbench Download
MySQL Server Download
MySQL Connector/ODBC 8.0 Download (note: 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)


' Connection string sample for MySQL Connector/ODBC 8.0:
ConnectionString = "DRIVER={MySQL ODBC 8.0 Driver};Port=3306;SERVER=127.0.0.1;DATABASE=test;USER=root;PASSWORD=mypass;OPTION=3;"

' Connection string sample for MySQL Connector/ODBC 8.0:

ConnectionString = "DRIVER={MySQL ODBC 8.0 Driver};Port=3306;SERVER=127.0.0.1;DATABASE=test;USER=root;PASSWORD=mypass;OPTION=3;"

MySQL Connector/ODBC 5.3 Download
(note: 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)


' Connection string sample for MySQL Connector/ODBC 5.3 (should work also with MySQL Server 8.0):
ConnectionString = "DRIVER={MySQL ODBC 5.3 Unicode Driver};Port=3306;SERVER=127.0.0.1;DATABASE=test;USER=root;PASSWORD=mypass;OPTION=3;"

' Connection string sample for MySQL Connector/ODBC 5.3 (should work also with MySQL Server 8.0):

ConnectionString = "DRIVER={MySQL ODBC 5.3 Unicode Driver};Port=3306;SERVER=127.0.0.1;DATABASE=test;USER=root;PASSWORD=mypass;OPTION=3;"