DAO to mySQL module

We are using the mySQL ODBC 5.1 driver. We need a VB6 classic Class module capable of doing the following: Open mySQL database on remote Linux server, using VB6. Standard Port 3306 Select any mySQL Table we want to work on Add/Edit/Delete any Field information in a mySQL database Optionally Add/Edit/Delete the same fields in a local DAO MDB Download all data from the mySQL database that has not been downloaded (Code should check for a True/False flag in the mySQL DB) Populate a Listview with all newly downloaded data and set the True/False flag in the mySQL DB as the data is downloaded to the Listview Class needs to allow us to Connect to server with Hostname, Username, Password and mySQL DB Name Class needs to allow us to Disconnect from mySQL Class needs to allow us to submit Table Name, Field Name(s) that we wish to download data from Class needs to allow us to submit data to the Table Name and any Field(s) we wish to add/edit/delete data from **NOTE:** RDO coding is acceptable to us. ## Deliverables 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement). ## Platform All versions of Windows XP, Vista and 7