We help IT Professionals succeed at work.

Why is MS Access requiring me to save queries?

pwdells
pwdells asked
on
Medium Priority
375 Views
Last Modified: 2012-05-11
Hi Experts,

It seems like it has been just recently, that I am now required to save every query that I make during production in the Design View.  This is really annoying because sometimes things are just for a quick temp look up.  So now, I have to give the query a bogus name, save it, then delete it.

Thanks,

Wendee
Comment
Watch Question

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Not quite following?
Are you making design changes?
Are you right click and filtering/sorting when in datasheet view? If so, Access considers those 'design changes'.

Also ... have you rebooted your system since this started (seriously) ?

mx

Author

Commented:
If I create a query in Design View and go to close the query, I have 2 choices (1) Save the query or (2) go back to Design View of the query.  I cannot close it without saving it.  Most of the time, I don't ever want to save the queries, they are just quick lookups, nothing I would every keep for future use.

I reboot my computer 2 times a day because I go between work and home with it.  So, yes, definitely I reboot.  :-)

Wendee
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:

 That's the way it works for me...

JimD.
CERTIFIED EXPERT
Top Expert 2009

Commented:
Just let them be saved as Query1, Query2, etc., and clean them up every once in a while.

Author

Commented:
That's weird.  I feel like I've been able to close (discard) a query upon closing, if I wish not to save it.

CERTIFIED EXPERT
Top Expert 2016

Commented:
open the VBA window, type

docmd.SetWarnings true

and hit enter

now try creating a query and close
CERTIFIED EXPERT
Top Expert 2016

Commented:
open the VBA window, type

docmd.SetWarnings true

in the immediate window and hit enter

now try creating a query and close
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
"I have 2 choices (1) Save the query or (2) go back to Design View of the query. "
Can you post a screen shot of this ?

What you should be getting is in the screen shot below ... is that Not what you are getting ?

mx
Capture1.gif
CERTIFIED EXPERT
Top Expert 2016

Commented:
he will get that dialog box after running the codes posted at http:#a35486256

Author

Commented:
I am NOT getting that.  Attached is my view.
SaveProblem.bmp
CERTIFIED EXPERT
Top Expert 2016

Commented:
pwdells, are reading my posts?
CERTIFIED EXPERT
Top Expert 2016

Commented:
pwdells, are you reading my posts?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
If Set Warnings was Off, there would be No prompt whatsoever.

mx

Author

Commented:
Cap: That does not work.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
OK ... looking at your image, I recall this same thing happened a while back ... and it seems the answer was to reinstall Access (or Office).  

mx
CERTIFIED EXPERT
Top Expert 2016
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I will try that.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
pwdells:
IF ... SetWarnings have been left set to False somewhere ... you would received *not* prompt whatsoever.  It would have automatically Save your query as is when click in the X button on the query.  If your system was working normally now, you could easily test this.

mx

Author

Commented:
As soon as Capricorn explained that the "DoCmd.SetWarnings (false)" had to be paired with "DoCmd.SetWarnings (true)" in each sub routine that I have an action query, it made complete sense.  Before that, it did not work, when I tried just "DoCmd.SetWarnings (true)".
CERTIFIED EXPERT
Top Expert 2016

Commented:
so you learned something New!!!

Author

Commented:
Indeed.  Everyday, I do!  :0)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.