user permissions and shift key on startup

[Bob Weisenburger]

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

[Joan Wild]

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