1,105,578 Community Members

Microsoft Access Prevention of retrieving password

Member Avatar
jealii.jealii
Newbie Poster
3 posts since Jan 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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?

Member Avatar
adam_k
Veteran Poster
1,056 posts since Jun 2011
Reputation Points: 239 [?]
Q&As Helped to Solve: 212 [?]
Skill Endorsements: 17 [?]
 
0
 

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.

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: