"Tony Toews [MVP]" wrote:

> BobK <B***@discussions.microsoft.com> wrote:
>
> >When I run an MDE in acess 2007 runtime, I get the action messages I.E. "1
> >record will be updated".  DO I use:
> >
> > DoCmd.SetWarnings False
> >to turn off these messages?
>
> You could but it's not recommended.
>
> I prefer, if DAO, to use Currentdb.Execute strSQL,dbfailonerror
> command instead of docmd.runsql.  For ADO use
> CurrentProject.Connection.Execute strCommand, lngRecordsAffected,
> adCmdText 
>
> If you're going to use docmd.setwarnings make very sure you put the
> True statement in any error handling code as well.   Otherwise weird
> things may happen later on especially while you are working on the
> app.  For example you will no longer get the "Do you wish to save your
> changes" message if you close an object.  This may mean that unwanted
> changes, deletions or additions will be saved to your MDB.
>
> Also performance can be significantly different between the two
> methods.  One posting stated currentdb.execute took two seconds while
> docmd.runsql took eight seconds.  As always YMMV.
>
> 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
>    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
>