Connect Microsoft Access to MySQL or SQLite - No DSN Needed

This is an update to a previous demo for creating DSN-less connections from an MS-Access application. This update covers both MySQL and SQLite. While you'll still need to download and install the MySQL or SQLite ODBC connectors, you won't need to create a DSN entry on each client machine. 00:12 - Creating MySQL connections 02:30 - VBA code overview 05:20 - SQLite example Find the code on GitHub - https://github.com/ajcomeau/MS-Access-to-MySQL-SQLite This repo was updated in June 2025. MySQL ODBC Connectors - https://dev.mysql.com/downloads/connector/odbc/ SQLite ODBC Drivers - http://www.ch-werner.de/sqliteodbc/ MySQL Connection Strings - https://www.connectionstrings.com/mysql-connector-odbc-5-2/ SQLite Connection Strings - https://www.connectionstrings.com/sqlite3-odbc-driver/ "Self-Guided SQL: Build Your SQL Skills with SQLite", is now available on Amazon.com! My newest book will help you master SQL using the SQLite database software. Bookmark the official page and subscribe to this channel for more updates! https://www.comeausoftware.com/self-guided-sql-sqlite/ Available on Amazon in Kindle and paperback (link will redirect) - https://www.comeausoftware.com/asgsyt Video title card auto-generated with ChatGPT. Music: Gittarenspiel (Deiter Robbins - https://pixabay.com/users/dieterrobbins-1335681/) #SQLite #MySQL #MSAccess #Databases #VBA #SQL