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
Alex Dybenko - 24 Feb 2006 06:02 GMT
Hi,
I think you can get this running docmd.SetWarnings false in immediate window

Signature
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
> The following message appears everytime I close an Access table useing
> Office 2003.
[quoted text clipped - 12 lines]
>
> RS
Tony Toews - 24 Feb 2006 20:26 GMT
>The following message appears everytime I close an Access table useing
>Office 2003.
[quoted text clipped - 3 lines]
>
>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

Signature
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