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

2007 - Changes in Query Builder won't save

P: 1
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
Jan 30 '08 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Feb 5 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.