Connect Microsoft Access to MySQL - No DSN required.
Ғылым және технология
This is a demo for creating DSN-less MySQL connections from an MS-Access application. While you'll still need to download and install the MySQL ODBC connectors, you won't need to create a DSN entry on each client machine.
Find the code on GitHub -
github.com/ajcomeau/MS-Access...
MySQL ODBC Connectors - dev.mysql.com/downloads/conne...
MySQL Connection Strings - www.connectionstrings.com/mys...
Music: Gittarenspiel (Deiter Robbins - pixabay.com/users/dieterrobbi...)
Пікірлер: 12
Amazing job, thank you very much
@ComeauSoftwareSolutions
7 ай бұрын
Glad you liked it!
thanks
@ComeauSoftwareSolutions
Жыл бұрын
You're welcome!
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.
Andrew, where is you tip jar !!!!!!!! Thank you so much!
@ComeauSoftwareSolutions
Жыл бұрын
You're welcome!
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