Access change my query and then can't open it

[weekend00]

I created following query in SQL view:

SELECT a.customer, b.customer
    FROM Orders AS a LEFT JOIN 
 
    (select customer from orders WHERE stuff="Turkey" AND 
   Year([orderdate])=2010) AS b 
 
  ON a.customer = b.customer

   WHERE (((a.stuff)="Turkey") AND ((Year([a].[orderdate]))=2009) AND ((b.customer) Is Null));

Then I save and close it. When I open again, it was changed to ("()" has been change to "[]."):

SELECT a.customer, b.customer
    FROM Orders AS a LEFT JOIN 
 
    [select customer from orders WHERE stuff="Turkey" AND 
   Year([orderdate])=2010]. AS b 
 
  ON a.customer = b.customer

   WHERE (((a.stuff)="Turkey") AND ((Year([a].[orderdate]))=2009) AND ((b.customer) Is Null));

then, I have met these cases(sort from the best to the worst):
1 I close the query without any changing, it works fine;
2 I change something in the SQL view, save and close, it works fine;
3 I change something in the SQL view, but can't not save because of some error of JOIN, after I changed the []. to (), I can save and it works;
4 I change something in the SQL view, save and close, but it doesn't work because syntax error;
5 The query doesn't work because of "Syntax error in FROM clause", I need to modify it;
6 The query doesn't work because of "Syntax error in FROM clause", I can't open in design view because of "Syntax error in FROM clause"

Now I am in case 6, I can't modify it because I can't not design it. What shall I do? Is there a way to open directly in SQL view?

[Rixxe]

Two things to try:

1. Create a new empty database. Use File... Get External Data... Import to
import this query into the new database. Can you see it then? It might allow the query to work.

2. Type Ctrl-G to open the VBA editor and the Immediate window and type

Application.SaveAsText "queryname", "C:\My Documents\foldername\xyz.txt"

Open it in Notepad or something just to see if your SQL is still correct or not.

[weekend00]

I imported, it remained not working.
Application.SaveAsText get me the SQL.

Thank you Rixxe.

Is there any way to provent this error? Because it always happen and I need to modify it frequently.

[Rixxe]

As far as im aware, its a bug with Access.
I have had it happen to me a number of times, if you do find a way of stopping it happening let me know!

Cheers

Rixxe