sintax error in FROM clause. And then what???

R

rocco

Hello,
I got trouble.
I have a query that has always worked fine, and it still do!!. I need to
make few changes to it but can't open it!!! When I try to switch in design
view it says "Sintax error in FRON clause" and wont let me see the SQL sintax.
It is a fairly complex query and I'm thinking that the trouble could be the
*odd* changes Acces does by itself under some circumstance (i.e. replacing
(SELECT with [SELECT and so on...).
How can I overcome this thing?
I don't want to think I have to re-write from scratch...

Thanks,
Rocco
 
K

kingston via AccessMonster.com

Have you attempted to import this query into another database? This might
strip any odd corruption from the object. Otherwise, try the usual Compact &
Repair, decompile, or a backup file.
Hello,
I got trouble.
I have a query that has always worked fine, and it still do!!. I need to
make few changes to it but can't open it!!! When I try to switch in design
view it says "Sintax error in FRON clause" and wont let me see the SQL sintax.
It is a fairly complex query and I'm thinking that the trouble could be the
*odd* changes Acces does by itself under some circumstance (i.e. replacing
(SELECT with [SELECT and so on...).
How can I overcome this thing?
I don't want to think I have to re-write from scratch...

Thanks,
Rocco
Click to expand...
 
O

Ofer Cohen

You can always use this

?Application.CurrentDb.QueryDefs("QueryName").SQL

In the Immidiate window to get the sql of the query
 
Top