G
Guest
Hello,
I asked this question a few weeks ago, but I want to try something different
than the advice I was given if possible. I have made a database for our
financial department. I set it up with a logon form (just to see if I could
make it work) that prompts when username or password is incorrect and will
shut down the application after 3 attempts. This was coded in VB. Now, our
CFO likes this db so much she wants to expand it to other departments with
their own forms, but all departments concerned can't see certain info. I
want to know if it is possible, in VB, to code "permissions" based on db
logons. As an example, I have on main switchboard linking to all forms. If
a user logs on, can I code it so based on the logon they enter (which is in a
table containing username and password), they can only see or be able to
click certain command buttons on the main switchboard? I know Access has
security settings, but these can be confusing, and really, I just want to
know if I can do it in VB. Any help would be appreciated.
I asked this question a few weeks ago, but I want to try something different
than the advice I was given if possible. I have made a database for our
financial department. I set it up with a logon form (just to see if I could
make it work) that prompts when username or password is incorrect and will
shut down the application after 3 attempts. This was coded in VB. Now, our
CFO likes this db so much she wants to expand it to other departments with
their own forms, but all departments concerned can't see certain info. I
want to know if it is possible, in VB, to code "permissions" based on db
logons. As an example, I have on main switchboard linking to all forms. If
a user logs on, can I code it so based on the logon they enter (which is in a
table containing username and password), they can only see or be able to
click certain command buttons on the main switchboard? I know Access has
security settings, but these can be confusing, and really, I just want to
know if I can do it in VB. Any help would be appreciated.