limiting access

L

Lori

My database is finally getting ready to go live for my company and I have a
couple of security issues.

1. Is there a way to prevent anyone except the administrator from
"Unhiding" the database window? I only want people to have access to whats on
the menu.

2. I have employee evaluation forms set up in the database. Is there a way
to restrict viewing of a specific entry to only certain people (example:
Laurie, her boss and Senior management should be the only ones with access to
Laurie's evaluation and Laurie should be the only be able to edit one field
in this form) is this possible?

3. Finally, I know its possible to prevent editing once a form has been
completed but is it possible to recreate a button or field that once clicked
or checked will lock the form so it cannot be changed? Or use conditional
formatting so that any changes would be very obvious (like a different color
font)?
 
D

Darrell Childress

For #3, you can create a button and use the code.

Me.AllowEdits = False
Darrell

Have you also posted these questions to the security newsgroup? It seems
like you'd find more folks there with answers.

-- Regards Jeff Boyce Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/ Microsoft Registered Partner
I have
ato whats
on
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top