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

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


"PETER" <(E-Mail Removed)> wrote in message
news:92D7C1D2-40BC-42BD-9986-(E-Mail Removed)...
> 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

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

"Rick B" wrote:

> 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
>
>
> "PETER" <(E-Mail Removed)> wrote in message
> news:92D7C1D2-40BC-42BD-9986-(E-Mail Removed)...
> > 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
>
>
>