I am building a small access application. It is some kind of inventory application and several users will be working with it. I would like to password protect only several macros and forms in application so only the boss will be able to access them. Can be password placed in Access 2000 for one macro? I have to say I am not too proficient with Access so I hope answer will be easy.
It is possible to accomplish placing password in Access 2000 for one macro or one form, but unfortunately for you it requires some coding and advanced knowledge of Visual Basic and Access. Maybe the best starting point for you is to visit Microsoft knowledge base and find article ID 209871. In this article you will find very detailed explanation (with some code) of procedure needed to set password in Access 2000 for one macro.