Prompt to Save?

[jadeverell]

Hi,

I have noticed that when i am editing an object within my database, specifically a query and click to close it, it doesn't prompt me to save the changes and does it automatically. There have been cases where i do not want to save the changes and just wanted to know if there was a simple setting to turn off automatic saves??

Thanks

James

[JustJim]

Hi,

I have noticed that when i am editing an object within my database, specifically a query and click to close it, it doesn't prompt me to save the changes and does it automatically. There have been cases where i do not want to save the changes and just wanted to know if there was a simple setting to turn off automatic saves??

Thanks

James

Hi James,

What version of Access are you using? My experience is that whenever you make a change to anything within Access and go to close it, you are asked if you want to save changes. Sometimes annoyingly so!

Jim

[jadeverell]

Hi Jim,

I am using version 2003.

The problem is, when i amend data in a table (maybe for test reasons) or edit the SQL within a query and go to close it it saves my changes automatically, even though i didn't want to save......very annoying also! :O)

Thanks

[jaxjagfan]

Make sure if any of your processes are using

Docmd.Setwarnings False

That at the end of the process you include

Docmd.Setwarnings True

Otherwise all warnings for data changes and object changes are turned off and are automatic.

[missinglinq]

You should always use Docmd.Setwarnings False and
Docmd.Setwarnings True in dandem, of course, but be aware: If your code bombs between the two, Access will be left with Docmd.Setwarnings False in place! So anytime you use them in a sub, you should include Docmd.Setwarnings True in your error handling routine.

Welcome to TheScripts!

Linq ;0)>

[JustJim]

Both >4 and >5 are correct and good advice. I would also add that I habitually insert

CleanUpAndLeave:
DoCmd.SetWarnings = True
DoCmd.HourGlass = False
Set (any databases, connections, recordsets etc) = Nothing
Exit Sub

into any sub I write with more than about 5 lines... and before any Error Handler I use.

I don't think this answers your main question though. Any time you make a change to an object, Access should be asking you if you want to save changes when you close that object.

Except when you change data in a table, either directly or via a query or form (which would be based on a table or query anyway). That does get saved automatically*. As my mate Bill Gates used to say "That's not a bug, it's a feature"

Jim

* but that can also be intercepted programatically.