2007 - Changes in Query Builder won't save

[Serendip]

Hi,

New to 2007(SP1), but have used Access extensively since 2.0. When I invoke the query builder to make changes to a form or reports underlying query, I just can't get it to save the changes I make.

I'm having to copy the SQL to a new query, make my changes in that query, and then paste the SQL back to the form/reports record source.

I've searched the web, but can't find anything on this - has anyone else come across it, or am I missing something here?

Cheers

[MMcCarthy]

There is a bug in Access 2007, in that if you open the query builder from the property window and you don't move to a different property in the property sheet before you close the property window, you lose the changes to the SQL statement (or you can even crash Access.)

There's no fix yet that I know of. But once you know about it, you develop the habit of pressing enter to move to a different property and ensuring that one is applied.

Also another reported issue is that for some reason when you open the query builder from properties window the builder is not modal as it was previously and you can close the properties window before you close the builder. If you do this then any changes will not be saved.