Action Queries

  • Thread starter Thread starter charles
  • Start date Start date
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
 
They could be turned on in code.

DoCmd.SetWarnings False
'Run a query
DoCmd.SetWarnings True
 
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
 
Back
Top