Action Queries

C

charles

Hi,

I deselected the options to confirm record changes,
document deletions and action queries. The users access
the database via terminal services using frame relays and
are sometimes presented with the option to confirm the
above. What can be the cause of this? Any suggestions...


HELP...


Charles
 
J

Joe Fallon

They could be turned on in code.

DoCmd.SetWarnings False
'Run a query
DoCmd.SetWarnings True
 
T

Tim Ferguson

sometimes presented with the option to confirm the
above. What can be the cause of this? Any suggestions...
Click to expand...

Rather than DoCmd.RunSQL, try using db.Execute command, dbFailOnError

You get longer SQL strings, and you can trap any errors that get returned.

HTH

Tim F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Confirmations still opening 2
Confirm action query runtime option 1
Action Queries 3
Table Security in Access 2013 1
turning off action queries 3
action query message 1
turning off action query confirmation dialogs? 1
Shapes menu, Actions missing 2

Top