Access 2002 Runtime

[Graham]

I have noticed that when i distribute an App using the
Access 2002 runtime, that upon running every action query
etc. that is run, prompts the user.
Very easy to turn off this in Access, anyone know how to
turn off in the runtime (as i use many action queries!).

Thanks

Graham

 

[Cheryl Fischer]

A couple of ways to do this...

- Use SetWarnings around each command to run one of your action queries;
i.e.,
DoCmd.SetWarnings False
...your query
DoCmd.SetWarnings True

- Use the CurrentDb.Execute syntax; i.e.,
CurrentDb.Execute "DELETE * from MyTable", dbFailOnError

hth,

 

[Graham]

Thanks for the info Cheryl, i will give it a go!

Graham