Member Avatar for jealii.jealii

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?

  • 2 Contributors
  • 1 Reply
  • 413 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by adam_k
Member Avatar for adam_k

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.