Is it possible to create a database which will have multiple users with each
user having their own password, then when logged in, only see specific data?
In a word, set up a workgroup security file. I strongly recommend to
give yourself a day or two to figure it all out. It is very powerful
and does exactly what you want it to as it is very highly
configurable. Beware - it is a little difficult to understand at
first. You can use the Workgroup wizard under Tools menu-Security-
User Level Security Wizard to get you going, but do take time to read
up on it, as it is tricky and EASY to leave huge security holes in
your database, which defeats the whole purpose of doing it.
Check out:
http://www.geocities.com/jacksonmacd/ for a great listing
of helpful articles.
I am working on a creating a workgroup file as we speak. Some key
points to remember (my 2 cents here):
1. Remove the Admin user from the Admins group, then set yourself up
as the user
1. Remove the Admin user from the Admins group, then set yourself up
as the user
1. Remove the Admin user from the Admins group, then set yourself up
as the user
(I repeated this for emphasis, but you get the point I am sure)
2. Everyone you add will be added to the Users group, as well as othe
groups you might create.
3. Don't set permissions on individual users, only Groups
4. If you want to give permissions for an entire Access object (say,
all forms) to a group, you can click on the first form, then hold the
shift key, and select the last form to highlight all. Clicking on
each form individually and setting permissions is way too much work.
If there are certain forms you don't want to include in a group, then
use the ctrl key to select the ones you want, then set permissions.
5. Don't hesitate to spend the time needed to really understand how it
all works. You'll be glad you did.
Good luck,
Don
