Summary

We converted several VBA SQL statements to statements to be run on the MySQL server and called them with passthrough queries. Some were simply passed to the server, while others were changed to functions or stored procedures, and the program still works. We looked at several possible issues that can arise when migrating a database to an application, and we worked through solutions; and finally, we removed the application's reliance on linked tables completely. In the next chapter, we will continue working with MS Access, deploying more advanced methods of using passthrough queries.

In Chapter 11, MS Excel VBA and MySQL – Part 1, we will be working with Excel and the MySQL database. Topics will include setting up connection functions with DSN and DSN-less capabilities; reading data from MySQL and setting ranges; populating data sheets, charts, and individual worksheet cells with MySQL data; and finally, we will be working with MySQL for Excel to create pivot tables...