Remotely Connect to MySql from MS Access
Yes, by using linked tables. Here's the MySQL documentation https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html

Add a User DSN from the ODBC Data Source Administrator, testing the link to your MySQL database to ensure you have the server, user name and password correct.

In Access on the External Data tab select ODBC Database. Choose the Link... option. Select Machine Data Source and the name of the DSN you set up. The tables available will appear. Choose the one(s) you want and click OK.