To prevent unauthorised users from opening an application, you can add a database password. However, a database password does not control what a user does once the application is opened. To set a password, the database must open in exclusive mode.
Make sure to keep a record of the database password. If you lose or forget the password, you cannot open the database or retrieve its data.
You can password-protect a database that contains tables that are linked to another database. You must provide the password to the back-end database in a connection string; you can save the password as part of the link to the tables. The password information is added to the end of the connection string by using the password identifier, PWD=password. To change the password, you need Administer permission to the database object
Caution: Because many people will share the same database password, it is risky to rely on the database password without implementing full user-security. One person could change the password and lock everyone else out. With full user-security, you can control who has rights to change the database password.
Unfortunately, people do lose or forget their passwords, making it impossible to access that data. Luckily, it does not mean that the data is lost forever. Check out the Microsoft Access Password Recovery Tools available.
Let's experiment by setting a database password using the sample database - MyNewApp.mdb..
You can remove the password you have set for a database. Once a password is set, the choice in the Tools, Security menu choice becomes Unset Database Password. You will be prompted for the password; it is case-sensitive. After you remove the database password, anyone has access to the database.
Let's remove the database password you set for MyNewApp.mdb
For the final tutorial in this section, let's take a look at Distributing the Secured Application
Go to page:
If you are serious about your Microsoft Access security, then you should check out Garry Robinson's book Real World Microsoft Access Database Protection and Security
About the book:
Microsoft Access is the most popular desktop database in the world today and its very popularity means that its security measures can be easily compromised. Real World Microsoft Access Database Protection and Security takes a different approach than all the other Access books in the market by focusing from the start on all the issues that will help protect your database. It approaches protection and security from a task-by-task perspective and provides details that when put together will make your database more secure.
This book will help you to keep your staff from looking at your salary tables, stop your customers from looking at the design of your software that you distribute, and help you decide which security options are worth doing and which are generally a waste of your time.
Garry writes from a very experienced developer's point of view and he discusses in detail how to program all types of security issues including hiding tables as system tables, producing databases that password cracker software cannot easily crack, backing-up databases, menus, queries, and even user surveillance.