Enable or disable automatic joins between tables and queries in queries

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.

1. On the Tools menu, click Options.
   
   
2. Click the Tables/Queries tab.
   
   
3. Select or clear the Enable AutoJoin check box.

Notes  

• If you disable automatic joins, you can still create joins yourself.
  
  
• This setting applies to new queries only.