Good day
This is one form interface from inside MSaccess to Link/import /Export tables from/to Mysql.
it works fine but I need some experts touches to deal with the listbox items that show currently available tables and show which is real one which is a linked one. and how to manage if the user uses different version of the mysql odbc connector ( here I am using 5.3).
This form should be imported by an I.T person to the current database in order to export its tables to the server and linking them again
AND this arrangements to be used in wire lan network (without internet) where each PC has a fixed IP number.
Here is a link for the mysql_connector
http://dev.mysql.com/downloads/connector/odbc/
One should choose the 32bit or 64 that matches his MS Access version not the windows version !
If anyone uploads a modified version of this
I would like to have a 2003 database format PLEASE.
Thank you in advance.
This is one form interface from inside MSaccess to Link/import /Export tables from/to Mysql.
it works fine but I need some experts touches to deal with the listbox items that show currently available tables and show which is real one which is a linked one. and how to manage if the user uses different version of the mysql odbc connector ( here I am using 5.3).
This form should be imported by an I.T person to the current database in order to export its tables to the server and linking them again
AND this arrangements to be used in wire lan network (without internet) where each PC has a fixed IP number.
Here is a link for the mysql_connector
http://dev.mysql.com/downloads/connector/odbc/
One should choose the 32bit or 64 that matches his MS Access version not the windows version !
If anyone uploads a modified version of this
I would like to have a 2003 database format PLEASE.
Thank you in advance.
Last edited:
