Turn off Microsoft Office Access Prompt "Red" <rspahr1[ at ]houston.rr.com> 23.02.2006 23:38:34 The following message appears everytime I close an Access table useing Office 2003. HEADER: Microsoft Office Access 'Do you want to save changes to the design of table 'dbo.xxxx_yyy'? Question: How does one turn this prompt off? Have tried looking in Tools, Options, Custom with no success. P.S. Would you please direct me to the proper Newsgroup should this newsgroup not be the correct newsgroup. Thanks for your attention RS

Re: Turn off Microsoft Office Access Prompt "Alex Dybenko" <alexdyb[ at ]PLEASE.cemi.NO.rssi.SPAM.ru> 24.02.2006 06:02:22 Hi, I think you can get this running docmd.SetWarnings false in immediate window -- Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com "Red" <rspahr1[ at ]houston.rr.com> wrote in message news:_HrLf.32301$7y1.5858[ at ]tornado.texas.rr.com... [Quoted Text] > The following message appears everytime I close an Access table useing > Office 2003. > > HEADER: Microsoft Office Access > 'Do you want to save changes to the design of table 'dbo.xxxx_yyy'? > > Question: How does one turn this prompt off? > > Have tried looking in Tools, Options, Custom with no success. > > P.S. Would you please direct me to the proper Newsgroup should this > newsgroup not be the correct newsgroup. > > Thanks for your attention > > RS >

Re: Turn off Microsoft Office Access Prompt Tony Toews <ttoews[ at ]telusplanet.net> 24.02.2006 20:26:52 "Red" <rspahr1[ at ]houston.rr.com> wrote: [Quoted Text] >The following message appears everytime I close an Access table useing >Office 2003. > >HEADER: Microsoft Office Access >'Do you want to save changes to the design of table 'dbo.xxxx_yyy'? > >Question: How does one turn this prompt off? You shouldn't be getting this message in normal use. Unless you are resequencing the view over the data by clicking on a column heading and then clicking on the Sort Ascending (or Descending) button. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm