Access 2007 Does Not Confirm Design Changes

[lastjackal1 via AccessMonster.com]

Using Access 2007 working on databases made using ver 2003. After making a
design change to anything (table, query, form, report), Access does not ask
if I want to save the changes, it just saves them. This seems to happen only
when working with databases that were originally created in earlier versions
of Access, i.e., if I make a new database using Access 2007 (saved in mdb
format) it asks for confirmation before saving changes. Does anyone no why
this is happening or how to get it to function correctly?

 

[Adam Simpson]

There is probably some code that has run that sets the warnings to off and
does not set them back on.
Ctrl G to the immediate window and type the following

docmd.SetWarnings -1

Then test saving

Adam

 

[lastjackal1 via AccessMonster.com]

That was it. I forgot to SetWarnings back to True in some code. Thanks Adam!

Lastjackal

There is probably some code that has run that sets the warnings to off and
does not set them back on.
Ctrl G to the immediate window and type the following

docmd.SetWarnings -1

Then test saving

Adam

Using Access 2007 working on databases made using ver 2003. After making a
design change to anything (table, query, form, report), Access does not

[quoted text clipped - 6 lines]

format) it asks for confirmation before saving changes. Does anyone no why
this is happening or how to get it to function correctly?