Connect Microsoft Access to MySQL - No DSN required.

[@majdighazal7440]

Amazing job, thank you very much

[@ComeauSoftwareSolutions]

Glad you liked it!

[@rekawt2]

thanks , But How can we clear (User Name and Password) after closing database so no one can open blank database and import linked tables

[@ComeauSoftwareSolutions]

The database doesn't save the user name and password - you type them in each time. The VBA code clears all linked tables before re-linking them.

[@MrVRAIMAROCAIN]

Unfortunately i get Error (3170) could not find installable ISAM

[@ComeauSoftwareSolutions]

This could be an Office or Access installation error on your machine. Try doing some Google searches on the error.

[@MrVRAIMAROCAIN]

@@ComeauSoftwareSolutions thanks, i fix it by adding mdac reference

[@deniscloutier383]

Andrew, where is you tip jar !!!!!!!! Thank you so much!

[@ComeauSoftwareSolutions]

You're welcome!

[@dbdata9836]

thanks

[@ComeauSoftwareSolutions]

You're welcome!