Syntaxerror in Designview -> How to correct wrong SQL-Syntax?

[Adfra]

Hi,

Situation is:
Used an embedded query which was "optimized" be Access with Brackets
("()" -> "[].").

Now problem is:
I get the error "Syntaxerror in From part" in normal view as well as in
the design view. When I click ok -> Error and Window close.

How can I correct the error (=Seperate the two queries) when the design
window closes staight away once I click Ok on the error msg?

Thanks!
Frank

[Beacher]

Where is the SQL located again? on form load? or in the properties?

[Adfra]

Designed the query in the regular query designer and edited later the
sql of the query.

There is no connection to VBA, macros, Forms or reports. I'm talking
just the plain query. Everytime I try to open it in any view it gives
me the error and on "OK" it closes the error window as well as the
query.

Beacher schrieb:

Where is the SQL located again? on form load? or in the properties?

[Ozzone]

If you can view the query in design mode, then the syntax should be ok
even after you've edited it manually in SQL mode.

[corey lawson]

the query designer will modify this:

select * from
(select * from some_table...)

like you noted, into something bizarro when you go back into Designer
mode.

If you change the alias, or add your own alias like so:

select vx.* from
(select vz.* from some_table...) as vx

then, the first time you go back to Design mode, it will work, but if you
go back into SQL Edit mode and back to Design mode, it won't like it, so
you have to take out the square brackets that it put back in around the
subquery when you changed back to Design mode last time.

"Adfra" <ad******@gmx.de> wrote in news:1118416892.675551.52330
@g14g2000cwa.googlegroups.com:

Hi,

Situation is:
Used an embedded query which was "optimized" be Access with Brackets
("()" -> "[].").

Now problem is:
I get the error "Syntaxerror in From part" in normal view as well as in
the design view. When I click ok -> Error and Window close.

How can I correct the error (=Seperate the two queries) when the design
window closes staight away once I click Ok on the error msg?

Thanks!
Frank

[Adfra]

Thanks for your explanations, but I'm sorry to say that it does not
explain the solution to my problem.
Again, my problem is NOT how I have to correct the brackets.

THE PROBLEM IS: I can't modify my query anymore.

I can't access the query because it gets closed due to the Syntaxerror.
Do you have any idea how I could access the query anyway?