Simple Security Requirement

D

David

Hi
I have an access database 2007- the users simply use buttons on a form- to
import data- run queries etc. I don't want them to see or certainly not
change any back end table structure or amend / delete queries etc- the only
way to change a table should be via a macro activitaed by pressing a button.
While I could stop them seeing ribbon etc- them pressing the shift button on
opening file opens it all up for them- is there an easy way to protect the
back end?
 
D

David

That great thanks for that- by the way when inputting my password is there
any way of only seeing ***** rather than the actual characters i typed- as I
often need to do this in front of the user?
 
D

Douglas J. Steele

Creating a form with a text box into which you type the password, and set
the text box's InputMask to Password.
 
D

David H

I built an app where access-rights were based on the User Id of the currently
logged on Windows User. The code grabbed the user id and then looked for it
in an underlying table effectively eliminating the need for passwords at the
application level. If someone did open the app that wasn't authorized, they'd
get a message indicating such.
 

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