I'm creating a password protected Volunteer Database and everything is going well. I have created a 'password protected' form before entering the hidden database(seperate form). How though am I able to prevent a 'user' to find out the password by going through "Build Event" in Access?
Create a separate db with your data (you can password protect this) and link the tables from your environment db to that. Password protect your VBA and when you are done developing go to Database Tools and use the option Make ACCDE. This will create a copy of the db in a "compiled" state that nobody can access the design view or the code behind forms. So you need to keep a copy of your "development" db to yourself and make changes if necessary. Make sure you also keep a backup development db, as ACCDE won't return to a normal access db.