You can create a database property named AllowBypassKey and set its value to
False.
See http://www.mvps.org/access/general/gen0040.htm at "The Access Web" for
the correct way to create this property.
However, I always cringe when people suggest using an environment variable
for this purpose, given how easy it is to reset an environment variable. All
a determined student needs to do is:
1. Open a command prompt ("DOS Box")
2. Type Set Username = xxx (where xxx is the ID of a staff member)
3. While still in the same command prompt, start the application (<full path
to msaccess.exe> <full path to database>). Environ("Username") will return
xxx
(Of course, should the student start the application outside of that command
prompt, Environ("Username") will be correct)
Far safer, in my opinion, is to use the GetUserName API call. See
http://www.mvps.org/access/api/api0008.htm at "The Access Web" for a
complete sample.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
> Hi,
>
[quoted text clipped - 14 lines]
>
> Thank you
DanielWalters6 - 16 Sep 2007 18:24 GMT
Hi
The school tech's are pretty hot on this type of thing, and all cmd isn't
allowed, even on the staff accounts.
Even such things as the New Task in task manager has been removed.
However, I understand you concern and reasoning, and will look at the links
you provided.
Thank you for your help
Dan

Signature
Dan Walters
> You can create a database property named AllowBypassKey and set its value to
> False.
[quoted text clipped - 37 lines]
> >
> > Thank you