A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access 2007 Does Not Confirm Design Changes



 
 
Thread Tools Display Modes
  #1  
Old December 15th, 2009, 07:19 PM posted to microsoft.public.access.tablesdbdesign
lastjackal1 via AccessMonster.com
external usenet poster
 
Posts: 2
Default 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  
Old December 17th, 2009, 04:22 PM posted to microsoft.public.access.tablesdbdesign
Adam Simpson
external usenet poster
 
Posts: 7
Default 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  
Old December 18th, 2009, 01:02 AM posted to microsoft.public.access.tablesdbdesign
lastjackal1 via AccessMonster.com
external usenet poster
 
Posts: 2
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:57 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.