>I made an application on Access97 and I distribute it to people who does not
>have Access on their machine by using the ODE tools. They are all NT4.0
>clients.

>The application works fine, but anytime the user tries to make something
>that runs in the background a piece of code that makes a change on some
>table, s/he has to confirm a message such as "You are about to update 12
>rows from the specified table... Are you  sure?..." e.g. , as if the
>Tools/Options/Edit-Find/Confirm/Action Queries is checked. (BTW, I mostly
>use docmd.runsql to run sql statements that make changes on my tables).

> >I made an application on Access97 and I distribute it to people who does
not
> >have Access on their machine by using the ODE tools. They are all NT4.0
> >clients.

> >The application works fine, but anytime the user tries to make something
> >that runs in the background a piece of code that makes a change on some
> >table, s/he has to confirm a message such as "You are about to update 12
> >rows from the specified table... Are you  sure?..." e.g. , as if the
> >Tools/Options/Edit-Find/Confirm/Action Queries is checked. (BTW, I mostly
> >use docmd.runsql to run sql statements that make changes on my tables).

> I prefer currentdb.execute strSQL,dbfailonerror as this doesn't give
> you those messages.

> You can put a docmd.setwarnings false statement in but make very, very
> sure you put in the docmd.setwarnings true in afterwards including in
> any error handling.  Otherwise various defaults will be applied to
> messages which you didn't want taken.

> Tony
> ----
> Message posted to newsgroup and, if appropriate, emailed.
> Tony Toews, Independent Computer Consultant
> Microsoft Access Links, Hints, Tips & Accounting Systems at
>    http://www.granite.ab.ca/accsmstr.htm
> VolStar http://www.volstar.com Manage hundreds or
>    thousands of volunteers for special events.