Stopping Shift at startup

[mcrafters]

I have a database all set up and i don't want anyone to change it on me by
holding down shift when they start it. How do i shut off this option

 

[Douglas J. Steele]

You need to create a database property named AllowBypassKey and set its
property to False.

See http://www.mvps.org/access/general/gen0040.htm at "The Access Web" for
the proper way to create this property. (Note that the code illustrated uses
DAO. If you're using Access 2000 or 2002, make sure you have a reference set
to DAO in order to get the code to work)

 

[mcrafters]

After trying this all of my access databases now have this protection. I only
want it to apply to one of them. When i transfer this database to another
computer with it's own copy of acces this protection is not transfered. How
can i set up this protection to only this aprticular database without
effecting other databases. and be able to have this protection applied to any
computer it's installed on?

 

[Douglas J. Steele]

What I pointed you to only applies to a single database, and it will travel
with the database.

You do realize that you run the code indicated once, and it takes effect the
next time you open the database?