A
Archives
First, happy new year for everyone
I use a MySQL database and Microsoft Access. I would like to know what is
the best solution to send request to MySQL using VBA. I counted 3 different
ways:
- with ODBC, using DAO or ADO with the recordset objects. I read that ODBC
is a little bit slow but we need ODBC to use forms and reports I presume ?
- with API. The direct requests (like Insert, Delete...) are quicker but the
return of rows is very hard(and time consuming ?) with a Select.
- with MyVBQL, I only know that it exists. But is it reliable, do we have
some support of this dll in the next future ?
Thank for your help to compare these three ways.
Regards
I use a MySQL database and Microsoft Access. I would like to know what is
the best solution to send request to MySQL using VBA. I counted 3 different
ways:
- with ODBC, using DAO or ADO with the recordset objects. I read that ODBC
is a little bit slow but we need ODBC to use forms and reports I presume ?
- with API. The direct requests (like Insert, Delete...) are quicker but the
return of rows is very hard(and time consuming ?) with a Select.
- with MyVBQL, I only know that it exists. But is it reliable, do we have
some support of this dll in the next future ?
Thank for your help to compare these three ways.
Regards