Access Runtime 2003 : You are about to delete records message

[MarkI]

I've just made a runtime version of my database and the user is being
prompted to confirm record changes/deletes. In my frontend the confirm
Record Changes, Document deletions and action queries are all unchecked.
It's only the runtime user being prompted. How do I stop the confirm
prompts from showing in the runtime version?

Thanks

 

[Albert D. Kallal]

As a general design rule, I always used:


currentdb.Execute "name of query or sql goes here"

The above does not prompt for confirmations.

You likely using docmd.RunSql, so you have go:

docmd.SetWarmings False

..... you runsql code goes here

docmd.SetWarnings True.

Remember, you could also modify the actual settings in the tools->options
(via code for runtime).
However, I recommend you use the above setwarings..and always "pair" the
turning off/on of setwarmings.

The above is preferred in place of modifying the setup options. If you
modify the setup options then what happens if the user has the full version
of ms-access, and runs other applications. If you modify those settings,
then they will be expecting confirmation for deletions of records. I don't
think you need a lecture as to how angry a user of your applications would
be if they found out that it your program that turns off the conformations
in all other applications....

So, use the above setwarnings, or replace your runsql with currentdb.execute