Database window

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pietro - 25 Jul 2007 17:44 GMT

Hi all,

Th fact that busers can view the database window by pressing on the shift
button is very frustrating for me,because,through my form, i put restrictions
to users so as to get my wotk in the best way,but actually users now can
easily enter to the databse window,view hidden objects and change data
through the tables and the queries..
Is there any way to stop this?

Reply to this Message

George Nicholson - 25 Jul 2007 19:36 GMT

http://www.mvps.org/access/general/gen0040.htm
General: Securing AllowBypassKey

Usage example:
ChangeProperty("AllowBypassKey", dbBoolean, False)

(False to disable Shift bypass, True to allow it-the default )

I'll echo the comment: "...And don't lock yourself out!..."
I usually have a click event tied to a logo on some form that asks me for a
password and then allows me to (among other things) enable/disable the shift
key.

Safety First! Backdoors & backups!

HTH,

> Hi all,
>
[quoted text clipped - 6 lines]
> through the tables and the queries..
> Is there any way to stop this?

Reply to this Message

Pietro - 25 Jul 2007 20:52 GMT

Thanx alot,very beneficial,but i tried to copy the code and paste it in a new
module,when i opened the database nothing happened,note that i'm not very
well experienced in Access.
Your quick reply is highly appreciated

> http://www.mvps.org/access/general/gen0040.htm
> General: Securing AllowBypassKey
[quoted text clipped - 23 lines]
> > through the tables and the queries..
> > Is there any way to stop this?

Reply to this Message