[AccessD] POLL: Access Security

John:

I'm probably a hefty 2.  I doubt I'd need to have any books...We have one
large County (Recorder's Office) client that has the full Access security
invoked (I've done others, but not on this scale).  It's been years in the
making (was just installed about a year and a half ago and is still
working...) and it took a lot of time to get it all tweaked properly (not
Access security issues but the Client kept changing the requirements....:o).
And only ONCE did we get it locked down so well neither of us (two
programmers) could get into it.  Taa daa!  Praise the Lord for BACKUP
copies.

The security on this system works well, but one caveat, and it's probably
true with ANY type of global security, is that when you need to make
changes, additions, etc., you have to make sure that whatever it is you are
changing or adding, security must be a major part of the modification.
Since I deal with questions from this client weekly, if not daily, I get to
keep up on all their security as well...!!!

Greg Smith
weeden1949 at hotmail.com


----- Original Message ----- 
From: "John W. Colby" <jcolby at colbyconsulting.com>
To: "AccessD" <AccessD at databaseadvisors.com>
Sent: Wednesday, November 12, 2003 6: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
>