Enable or disable automatic joins in queries (MDB)
Even if you haven't created relationships between tables, Microsoft Access automatically creates joins if you add two tables to a query and the tables each have a field with the same or compatible data type and if one of the join fields is a primary key. You can enable or disable these automatic joins.
- On the Tools menu, click Options.
- Click the Tables/Queries tab.
- Select or clear the Enable AutoJoin check box.
Note This setting applies to new queries only.