[AccessD] POLL: Access Security

4.5

Had to fool with it once on a legacy app and got around it.  But it was a
big PITA.

I generally roll my own by having the user log in with a password.  They get
one of three levels of access to the whole system - 1) read only, 2)
read/write, 3) admin.  I put their access level in a global variable.  Each
form has to check the access level then to see if they are allowed to do a
certain function.  So far, the three levels have been adequate and no one
except for one client has wanted function of field level control.

Rocky

----- Original Message ----- 
From: "John W. Colby" <jcolby at colbyconsulting.com>
To: "AccessD" <AccessD at databaseadvisors.com>
Sent: Wednesday, November 12, 2003 4:59 PM
Subject: [AccessD] POLL: Access Security


> I'd like to take a poll regarding your knowledge of Access' built-in
> security. By security I do NOT mean the database properties, rather using
> workgroups / users to secure forms, tables, queries etc.
>
> Anyone interested in participating please choose one of the following:
>
> 1) I am an Access security guru.  I can quickly and easily lock a database
> down so tight I can't even get back in.  No help / books needed.
> 2) I am fluent with Access security.  I can get the job done but it
> definitely takes a few hours.  I probably won't need the help / books.
> 3) I have done Access Security on at least one real paying project.  I
would
> need help / books to do it again.
> 4) I have heard about Access Security, read about it, managed to shoot a
toe
> off, maybe played around with it, but I am confident I could get the job
> done.  Books / help definitly needed.
> 5) Access has built in security?  What is this and where would I go to
learn
> it?  Why haven't I ever seen these books / help?
>
> If you would please just select a number and reply I would appreciate it.
>
> As for myself, I must admit I rate a solid 4.  No client has ever been
> willing to pay for it and I have always had other things to learn / do so
I
> just never did it (for real).
>
> John W. Colby
> www.colbyconsulting.com
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>