By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

user permissions and shift key on startup

P: n/a
If a user starts up access while holding down the shift key, the
database will open without going to the startup form. This allows the
user to actually open a table and change data that he would not
normally be able to change. His user name would not allow him to open
a form that give him access to all fields in a record. Normally he is
restricted to a form that only shows fields that he is allowed to
change.

Is there a way to keep the user from starting up an access database
while holding down the shift key?
thanks
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Bob Weisenburger wrote:
If a user starts up access while holding down the shift key, the
database will open without going to the startup form. This allows the
user to actually open a table and change data that he would not
normally be able to change. His user name would not allow him to open
a form that give him access to all fields in a record. Normally he is
restricted to a form that only shows fields that he is allowed to
change.
He shouldn't have permission on the table to begin with. Instead create a
RWOP (run with owner permissions) query and base your form on that. Give
them the necessary permission on the query, and deny all permissions on the
tables.

Is there a way to keep the user from starting up an access database
while holding down the shift key?


To disable the shiftkey bypass see
http://www.mvps.org/access/modules/mdl0011.htm
and
http://www.mvps.org/access/general/gen0040.htm
--
Joan Wild
Microsoft Access MVP
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.