Disabling Debug

[Tatakau]

I am having a difficult time converting my database to an MDE while still
allowing my mail merges to work with Word. Security prevents a user from
viewing the form code normally, but they can still get to it if they hit the
Debug button on errors. Until I can fix my MDE problem, is there a way I can
turn off the Debugging option?

Thanks!

Nick

 

[Tatakau]

Found it out. Sorta. Setting a password on the VB code will cause it to not
give you the option to debug unless you've already typed in the password
while trying to edit.

In the VBA editor, under Tools > Database Properties > Protectiion Tab, you
can lock the project for viewing and set a password. Definitely a good idea
if you're distributing an MDB.

Nick