Microsoft Access Prevention of retrieving password
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.
I've developed an app that takes the data in a text file and moves it to specific columns in an Excel file. My computer has the Excel 2010 installed. So the application works fine with no issues. However we've begun to upgrade computers and software in the office ...