This is a demo file 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.
MySQL ODBC Connectors - https://dev.mysql.com/downloads/connector/odbc/
MySQL Connection Strings - https://www.connectionstrings.com/mysql-connector-odbc-5-2/
See more about this demo on YouTube - https://youtu.be/CXV9-yQ4NVk
This is a demo file for creating DSN-less SQLite connections from an MS-Access application. While you'll still need to download and install the SQLite ODBC connectors, you won't need to create a DSN entry on each client machine.
You will need either the 32-bit or 64-bit SQLite3 ODBC Drivers, available from: http://www.ch-werner.de/sqliteodbc/.
SQLite Connection Strings - https://www.connectionstrings.com/sqlite3-odbc-driver/