Login Permissions

[Louis Herndon]

Hello,

I have created a database for our Financial Departments
many various forms. The CFO liked it so much she told
other departments and now they want their forms on it as
well. My initial setup was using a logon box for the CFO
and her secretaries, as well as myself. This was
basically just a plain logon that would close the
application if the user name or password was incorrect.
Now, with the upcoming additions she requested, all users
should not have access to the same forms, yet they want
them on the same database. I need to figure out how to
either set permissions so a user, based on their logon,
will be able to or not to see certain forms. How can I do
this with Access? I know I can either give them access to
the one main switchboard, and grant/deny visiblity to the
command buttons, or I can make different switchboards
which will come up based on logon. Which would be the
best way? Any help would be appreciated.

 

[Rick B]

You need to use the built in access User-Level Security. This will allow
you to create userid and password for each user. They can be assigned to
"groups". You can define exactly which objects each group can access. You
will be able to determine if they can view, change, add, delete, design,
etc. for each object.

Using your current "security" scheme, I'd bet that all anyone would need to
do is hold down the "shift" key whilee your database opened. This would
prevent the auto-run form from popping up and would let them go directly
into your objects.

Using your current security, anyone, anywhere could get to your data.

Setting up User-Level security is confusing at best. Read the security
white pages on the Midcrosoft website several times and follow EACH STEP IN
ORDER. Make at least one good backup before you start.

Good Luck!

Rick B

 

[Louis Herndon]

Thanks Rick,

Yeah, I know this isn't the most secure thing. When I was
first asked to do this database, it was just supposed to
be a good "pretty yet functional" alternative to Excel
spreadsheets. The popup logon box was my idea just to see
if I could do it. I am no VB expert, but have learned a
lot based on my needs, such as the logon/password access,
and playing with timers and graphical gadgets. The CFO
wanted it to look nice... and the switch, forms and
reports all work beautifully. Hmm, now to make it
secure...