Hiding certain fields

G

Guest

I have a database that I have set up access for two users. I want DBAdmins
to have full access and be able to view all fields. Other users will just
use the Admin account an I want to elminiate the ability to view password
fields. Is this possible?
 
J

Joan Wild

You can implement security, such that users don't login and instead use
their default system.mdw.

In the Open Event for your form(s), you can use code to hide controls that
you don't want the general users to see.

If CurrentUser() = 'Admin' then
Me!txtWhatever.Visible = false
Me!txtSomething.Visible = false
Else
Me!txtWhatever.Visible = true
Me!txtSomething.Visible = true
End If
 

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

Similar Threads

creating workgroupfile for remote administration 5
Confused with security set up 3
Programatically change a Number field to a Text field 1
Access security best practice - Stupid question(s) #2 7
Secured Access to Forms 1
Security - Am I missing something? 4
Word 2007 Missing User Level Securitty - ARRRGGGGHHHH What were they thinking? 10
Is it possible to create an MDE from an Access 2000 DB with ULS 3

Top