How-to #3
Create and open a secure Microsoft Access database
Problem
If a Jet (i.e. MS Access) database is available on a web site, how can
it be secured so that only authorised users can open it?
Solution
There are two ways to secure a Jet database. The simpler just requires
a password to open the database, and this is fine if all potential users
are to be granted full access. The problem is that once opened, a database
secured in this way may be read, written to, have sections deleted, etc.
by any user who can open it.
The alternative is to secure the database with user-level security,
which allows you to set different permissions for different users – some
can read the database, others alter or add records, etc. This leaves
two issues:
- how to create such a secured database
- how to open it in a web page using ActiveX Data Objects (ADO)
This how-to is divided into two parts, one for each of the above issues.
If you are not familiar with securing a Jet database in this way, read
the first section before the second. If you know how to do this, then
you can go to the second part (to follow).
1. How to secure an Access database with user-level
security
Home
page
| Graphics | Web design | Links | Contact
Archive |
About Microbion |
Site map | Privacy
policy
|
