user security

[BrotherOmar]

I setup a db with security. I added 2 users and assigned them to the read only group. I've noticed a problem with the security. Perhaps I am missing something in the security configuration. If one of the users exits the db and then re-enters the db using the shift key (bypassing the startup switchboard), they can look at all of the db objects--including all the tables.

This is a problem as the data is sensitive...I don't want them to be able to do this. Is there someway I can prevent this?

----
Tell 'em Omar back!

 

[jebry]

Hi!

You can disable the shift bypass key like this:


Dim prop As Property

Set prop = CurrentDb.CreateProperty("AllowByPassKey", dbBoolean, False)
db.Properties.Append prop

Put this code in a module somewhere and run it. Then close down the db and the property will take affect.

Please note that you will need to keep a development copy for yourself if you plan to totally lock up this database or put in code that only you can reach that will reset the AllowByPassKey to true:

CurrentDb.AllowByPassKey = True

Otherwise you might make the Db unchangable.
hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[BrotherOmar]

Thanks Jeff. Just the solution I'm looking for.

Omar

----
Tell 'em Omar back!