Simple Security Requirement

[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?

 

[Jack Leach]

Try this out...

http://www.tek-tips.com/viewthread.cfm?qid=1227966&page=1

hth
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)

 

[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?

 

[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.

 

[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.