Objects not prompting to save

Question

This has been occurring seemingly randomly in both Access XP and 2010 which is what we use at my company. Its also happened on different machines. When you close a from or report on which design changes have been made, you are supposed to get a prompt if you want to save the changes. But sometimes, Access goes into a mode where we don't get a prompt.

This has caused us to lose work because we aren't aware some setting has been changed and we just close expecting to be prompted to save.

The only possible cause for this I can think of is because I use Save No with the DoCmd.Close and if a close crashes. But I can't duplicate it.

Has anyone else experienced this and know of a solution?

---

Hope this helps, Scott<> P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2010 Blog: http://scottgem.spaces.live.com/blog Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries

Answer 1

This is something that I haven't run into before but in my current instance of Access 2010 I am not being prompted to save any objects.

The first thing I did was search my code for a SetWarnings which only occurs in one procedure which is set to true in the function exit. This procedure was not called anyway so could not have caused the issue.

The second thing I did was call "DoCmd.SetWarnings True" from the immediate window. This had no effect.

Then I shut the application down and reopened it. What was interesting was that the immediate window was not cleared but still had the calls from the previous instance.

So I shut it down again and opened up Task Manager. There was still a MSACCESS.EXE *32 process running in memory. 

Could not use GetObject from Excel VBA instance to get a reference to the running instance of Access even though it would be used when opening a database from Windows Explorer. Newer instances of Access opened through the start menu could be referenced with GetObject.

And the punchline. End Process restored the prompts.

Things I had done just prior to the incident. Excel Automation, set DisplayAlerts and ScreenUpdating to false, Reset the Access CodeProject in the middle, and set DisplayAlerts and ScreenUpdating to true through the immediate window. Things I've done a hundred times over in the past.

???

PaulE

Answer 2

Is it possible that you have some code that has set SET WARNINGS to off and then has not SET WARNINGS back on?

You should always make sure that you SET WARNINGS to True.  That means that if you have an error when running the code, your error handler must SET WARNINGS to TRUE.

Don't know if this is the cause of your problems, but I do get similar problems in the above case.  When this happens, you might try opening the immediate window and enter

      DoCmd.SetWarnings True

and then see if the problem still exists.

---

John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County

Answer 3

In addition to the Set Warnings issue, if you close the form in such a way to run Close with acSaveNo then that what it will do.  If you are making design changes, then the seemingly random save prompt might be because you are in design view or form view when closing the form.

Answer 4

Hi Scott,

It happened to me, too. I found that if you have SetWarnings set to False, then you don't get a confirmation window to save the changes. Make sure that SetWarnings = True when you design to make sure that you have control about saving your work.

Nadia

Answer 5

Scott,

just giving some feedback using Xp and 2007. i have had times when i dont get a prompt but the items are essentially being saved without my input.  i realize that this is opposite to not saving, i sometimes randomly do not get theprompt.

my 2 cents.

tighe