[AccessD] Strange Access Behavior

Stuart McLachlan stuart at lexacorp.com.pg
Mon Apr 24 07:22:44 CDT 2006


On 24 Apr 2006 at 7:51, ewaldt at gdls.com wrote:

> All right...more confusion. We all know that Access saves data
> automatically. Now, however, it also saves object changes automatically.
> That is, I make a change to a table in design view, then close design view.
> Access has always asked me if I wanted to save my changes. It does not do
> that now; it automatically saves the changes. I don't see anywhere that I
> could have set this as an option; has anyone else experienced this? Any
> suggestions as to how to get out of it?
> 

The only time I have ever seen this is after breaking out of a procedure or 
function which included a Docmd.Setwarnings False. Do you have any startup 
code which sets this anywhere?

What happens if you do a "Docmd.Setwarnings True" in the immediate window?

-- 
Stuart





More information about the AccessD mailing list