If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007 Does Not Confirm Design Changes
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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200912/1 |
#2
|
|||
|
|||
Access 2007 Does Not Confirm Design Changes
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" u56450@uwe wrote in message news:a0a2d52da1f47@uwe... 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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200912/1 |
#3
|
|||
|
|||
Access 2007 Does Not Confirm Design Changes
That was it. I forgot to SetWarnings back to True in some code. Thanks Adam!
Lastjackal Adam Simpson wrote: 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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200912/1 |
Thread Tools | |
Display Modes | |
|
|