Access VBA link to Mysql Database

I need to see a complete working example of VBA code running in a Microsoft Access database, which can read and write data from an example MySql database such as World-schema.sql

This is a first step in transition from an Access and Classic Asp database to Access and Mysql. running on the web, and may lead to a larger project.

The example is to run on a local Windows machine to which Mysql has been downloaded, not yet on the web.