I can eliminate the question "Are you sure you want to run this type of query?" in Access, but I am struggling to understand how to eliminate it when the .mde is used with only the RUNTIME on the computer. I have tried to change security and only caused problems. Any thoughts as to where to head next would be much appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Update query in Runtime 1
- Thread starter gsfmike
- Start date
-
1
- #2
Hi gdfmike,
A possible reason for this is that confirm Action Queries might be unchecked in Options. Runtime Access ignores this.
Docmd.Setwarnings False
'Put the query here
Docmd.Setwarnings True
This can be easily forgotten when deploying Runtime Access.
BP
A possible reason for this is that confirm Action Queries might be unchecked in Options. Runtime Access ignores this.
Docmd.Setwarnings False
'Put the query here
Docmd.Setwarnings True
This can be easily forgotten when deploying Runtime Access.
BP
- Thread starter
- #3
, 1 'on- Thread starter
- #5
- Status
Similar threads
- Question
- Locked
- Question