"TSanders" <ta*******@tamanders.net> wrote:
I created an Access database for a local telco that is split into a front
and back end. I would like to distribute the Access runtime along with the
front end. When I use the front end with the Access runtime, I must confirm
every time an action query runs from VBA. I know that in the full version
of Access, a user can opt to turn off notification every time an action
query runs from VBA. Can this option be exercised using the Access runtime?
Or can I maybe put a VBA module in that will stop the confirmation?
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