Unable to Set Relationship for Multiple Tables When Using Microsoft Access

Issue

The error below occurs after using Relationship with Access in Tableau Desktop.

Unable to complete action
This data source uses a connection that doesn't support multiple logical tables. Add a single logical table, open it, and then add the table in the physical layer of the data source.
For more information on logical and physical tables, see
https://www.tableau.com/en-us/app/om-physical-logical?build=20231.23.0310.1044&edition=pro&lang=en-us&platform=windows&version=2023.1

Environment

Tableau Desktop
Microsoft Access

Resolution

As a workaround, instead of creating relationships, add the second table in the physical layer of the data source. Steps are detailed below:
1. Drag the first table to the canvas.
2. Double-click on the table just dragged to the canvas (this will open the physical layer of the data source).
3. Drag the second table to the canvas.