By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,873 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Where is the SQL located again? on form load? or in the properties?

Nov 13 '05 #2

P: n/a
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?


Nov 13 '05 #3

P: n/a
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.

Nov 13 '05 #4

P: n/a
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


Nov 13 '05 #5

P: n/a
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?

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.