Does anyone know how to stop a user interrupting MS Access visual basic code execution using a "Control-Break" key combination.

It is possible to set the database properties to prevent VB code being exposed to a user when an unhandled error occurs, however this does not stop the code being transparently interrupted by a user.

AutoKeys does not recognise "^{BREAK}" as a valid key combination, so that seems to rule out using this approach to trap a "Control-Break".

Excel supports a method that allows "Control-Break" to be either trapped or ignored; MS Access does not appear to have an equivalent.

You can do all the fancy stuff you like, but if a user can stop your code in its tracks, your application has one very large flaw built right in!!

Go to the startup options and remove the USE ACCESS SPECIAL KEYS checkmark from the checkbox. That should do it for you.

__________________
Thanks,

Bob Larson
Access MVP (2008-2010, 2011)
Free Access tutorials, samples, tools

Wow, I'm curious as to why your users are using the CTRL+BREAK combination on any program! Are they purposely seeking to sabotage their work?!

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division