Query AutoSaves ?? 1

[mordja]

Hi,

a colleague of mine is having problems with access automatically saving queries when they are closed, meaning any unwanted changes he makes to the design are saved. He has not turned any features on or off. I have never had this problem. Is there an autosave feature in access related to queries ??

Thanks

Mordja

 

[GingerR]

If it's not prompting him with "Do you want to save changes" then that means he's turned off Warnings. Open a new code module, and put in this:

Function ResetDefaults()
Docmd.SetWarnings True
End Function

Then run the function. Prompt will come back on.

This happens to me sometimes when I turn off warnings in some code, but the code errors in the middle because of some bug and never hits the statement to turn the warnings back on. I keep a function like this in every one of my db's for just such a scenario. I also include:

Docmd.Echo True
Docmd.Hourglass False

just for good measure...

Hope this helps.



Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mordja]

GingerR,

Should have thought of it, Thanks!. Tracked down a module called by their autoexec macro in which warnings where turned off and not on again.

Mordja