Login permissions from custom built login form

[Guest]

I have built a login form which shows or hides all tool bars depending on the
user name and password. Can I also control the other permissons like being
able to edit forms and tables? I know I can do this using the MS Access
built in functionality, but can I do it programatically from my user login
screen.

I set the tool bar visibility, close the login form and open the main
switchboard using the "on click" button of my login form. Can the above
permissions controls be done here as well?

Thanks in advance.

Peter

 

[Rick B]

Peter:

Why would you want to build a custom login form and try to come up with ways
to limit access when this is all built in to Access? Even if there were a
way to do waht you ask, you are opening yourself up to so many back doors
and work-arounds that you would never be confident your data was safe.

As it is, the built-in security is not 100% effective. It is never
recommended for high-security situations, but it is certainly better than
anything that you could dream up from scratch.

In my opinion, you are making a mistake by trying to grow your own security.

Rick B

 

[Guest]

Peter,
I Agree 100% with Rick, you'll be spending more time trying to make your
custom security than enhancing your application,