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
 
Top