Okay. I have an Access database that I would like to upgrade to MYsql. I would like to put all my tables in the MySql server and keep the Access front end, since I have many forms and reports with VBA code in their events. I have a serious question though.
I understand how to use ADO to access the Mysql engine, but how about the forms that have bound combo boxes and bound recordsets. How do make a bound combo box that pulls all the records from a query, solely pull them out of the mysql tables and solely use the mysql engine. Because it is my understanding, that Access first uses its internal engine and then calls the database server producing an unnecessary amount of network traffic. So essentially, with bound forms and combo boxes, you loose the benefit of client server database engine.
Any suggestions because I have order data entry forms that have many bound combo boxes and additionally have subforms bound to table and queries.
Thankyou very much. I know its a hard and lengthy conversion. I would just like some tips in the right direction
Thanks
I understand how to use ADO to access the Mysql engine, but how about the forms that have bound combo boxes and bound recordsets. How do make a bound combo box that pulls all the records from a query, solely pull them out of the mysql tables and solely use the mysql engine. Because it is my understanding, that Access first uses its internal engine and then calls the database server producing an unnecessary amount of network traffic. So essentially, with bound forms and combo boxes, you loose the benefit of client server database engine.
Any suggestions because I have order data entry forms that have many bound combo boxes and additionally have subforms bound to table and queries.
Thankyou very much. I know its a hard and lengthy conversion. I would just like some tips in the right direction
Thanks
