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;"

Some Featured Excel Links:

Vertex42.com – Vertex 42 is mostly focused upon different Excel-templates, Excel calendars, Gantt Charts, personal budgets and debt reduction calculators. Jon Wittwer is the men behind this gigantic source of Excel templates. On Vertex 42 you can also find a lot of good tutorials, guides and articles about Excel.

Microsoft Access Programmers offering professional solutions for 25 years. Most of our clients are small to medium businesses. But we’ve also developed databases for the US Navy, The Virginia Tourism Corporation, the University of Maryland and Verizon.