Access 2007 Does Not Confirm Design Changes

  • Thread starter lastjackal1 via AccessMonster.com
  • Start date
L

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?
 
A

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
 
L

lastjackal1 via AccessMonster.com

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

Lastjackal

Adam said:
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
Click to expand...
[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?
Click to expand...
Click to expand...
 
Top