Problem: An attempt to open a query in Microsoft Access 2007 results in the "Join expression not supported" error. You can't see the query results nor edit the query to correct the alleged problem because the query view closes immediately. However, you can execute the query from VBA and even export its results to Excel.
in the VBA editor will let you see the (incorrect) query definition. You can set the same
SQL property to a new string to override the query definition. However, due to a bug in MS Access in handling JOINs the query might stay unopenable despite attempts to repair:
This problem occurs when a query contains a JOIN expression which links two tables using more than a single column in each of them. For example:
SELECT a.* FROM a LEFT JOIN b ON (a.col1=b.col1 AND b.col2='value')
Access tends to automatically and incorrectly strip the parentheses from the join expression, which leads to the error message mentioned earlier.