Use this guide to learn how to easily create and manage a MySQL 8 user with remote access to all databases.

Start with the File/New command in Access and create an empty database. Then choose Get External Data from the File menu and select Import rather than Link tables from the Get External Data submenu.