Login Form

C

ChrisBat

Hi,

I'm trying to build a form that allows the same security as the Security
Wizard, but without going through the wizard. For example, there would be a
ID Field and a Password field, linked to a table; I know I can do it by
putting in all the IDs in the Validation Rule for the field, but this is way
too complicated - I'm thinking of VBA, but don't know how I would write it.
Any suggestions? Thanks,
Chris
 
R

Rick B

Why? You are trying to reinvent the wheel. And you will never get it to be
even 1/2 as secure as User-Level Security (which has a few flaws itself!)

Do a search and read the hundreds of previous posts where we talked people
out of this and explained the reasons why this is a bad idea and a waste of
time and effort.
 
C

ChrisBat

I was thinking that I could build the form to have multiple options, not just
the Login/ID fields- i was also thinking of putting on Function Type, etc.
instead of having the person selecting it after the fact........However,
given the response you've given me, I'm going to use the wizard. Where can I
find an article on the different user types and their capabilities, what I
would need to set them up to do basic functions etc. etc? I am fairly decent
in Access, but this is the first time I'm securing a database and don't want
to screw it up given it's purpose (Vice Presidential follow ups....)
Thanks a million,
Chris
 
R

Rick B

I'd advise you to make a backup copy or two and read the following links
before proceeding. Setting up security is not easy the first time or two,
but is the best way to handle your situation...

Post back if you have any questions!!!

Good luck.

Security FAQ

http://support.microsoft.com/?id=207793



The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm
 
C

ChrisBat

Thanks a lot Rick, I'll take a look at the docs and post back if I've got a
problem........
Chris
 
Top