prevent view of code window

[Guest]

When an error occurs, the user gets a message with two buttons, End and
Debug. How can I prevent the user from clicking Debug and getting to the code?

I have looked in the Help and it says "The easiest way to set this property
is by using the Allow Viewing Code After Error option in the Advanced section
of the Startup dialog box, available by clicking Startup on the Tools menu."
My screen does not have an Allow Viewing Code After Error option --- what's
up with that.

Access 2000 SP-3 in WIndows 2000 Pro.

Thanks in advance.
Max

 

[Allen Browne]

You can mess with settings under:
Tools | Options | General | Error Trapping
(from the code window), but the only real solution is to use error-handling
in every routine throughout your application.

You do want to know what errors occurred, and you can't rely on users to
write them down for you, so you will want to log them. For a description of
how, see:
Error Handling in VBA
at:
http://allenbrowne.com/ser-23a.html

Another way to ensure users are never shown the code is to create an MDE and
give that to each user as the front end of your application.