cant save nested queries

[weezles]

hi

When i try to save a nested query Access shuts down. The queries run fine and give results, its only when i go to save them.

I am using Access 2002 on Windows XP with 512MB RAM. They work fine on my home machine using Access 2000.

Any suggestions?

Thanks

Lou

 

[PHV]

Before saving the nested query go to the SQL view pane, rplace all [red][ ].[/red] pairs by [green]( )[/green] and then click the floppy icon and don't go in the query grid !

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[weezles]

Hi

I've just installed Office xp Service Pack 3 and nested queries are working perfectly now.

I do find the fact that Access finds the need to contiually change the brackets back to [] highly annoying though.

Thanks

Lou