Password for vba editor ?

[kkgusta]

I have create a simple Access db and froms. Whenever user encounter an runtime error in the from Access will ask user to debug and the vb editor with the related vba code will be display. Is anyone know how to disable or setup some security like password login on the vb editor that limit the user to access to the code?

 

[PHV]

Why not using a .MDE ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Zion7]

if not an .mde then, add error handling to ALL, you subs.
Then, you can control what user interaction, if any,
is available.
MzTools or Zada.uk offer utilities which will add error
handling to every routine, in your DB, at once.

 

[ZmrAbdulla]

While you are in the VBE editor

TOOLS > {yourdbname}PROPERTIES > PROTECTION > LOCK PROJECT FOR VIEWING=TRUE
set your password too

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.