Re: Using Shift-Startup

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"DanielWalters6" <DanielWalters6@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:66E10B82-9539-4333-AD7D-9D1D4F5F30BB@xxxxxxxxxxxxxxxx
Hi,

I'm building an access application, which tracks IT Labs at the local
college.

It will be placed on a shared drive, where students have read-only access
and staff have read and write access.

The system uses a piece of code ( Username = (environ("Username")) to work
out the person accessing the code and based on their username, displays a
different form at startup. (Students see the VIEW timetable, Staff see
MAKE A
BOOKING...)

Is there a way to stop students by-passing the initial startup, by holding
shift?

Thank you

--
Dan Walters


.

Relevant Pages

  • Re: Using Shift-Startup
    ... While still in the same command prompt, ... It will be placed on a shared drive, where students have read-only access ... and staff have read and write access. ... Is there a way to stop students by-passing the initial startup, ...
    (microsoft.public.access.security)
  • Unable to change password due to the following error: 1909
    ... Check the Security Policy for user accounts in your ... complexity requirements" enabled. ... passwords which match the username, ... >new students logging for the first time. ...
    (microsoft.public.win2000.security)
  • Re: NT4 Disallow multiple logins
    ... >> school and my client base comprises primarily of Students.) ... > specify access times and logon machines this ... > will allow the logon *only* in the defined time ... in 20 times by passing his username and password to 19 other students? ...
    (microsoft.public.security)
  • Unable to change password due to the following error: 1909
    ... a student is assigned their username for access to the campus ... However, students have been reporting that after they initially login, ... they recieve the following error message: ...
    (microsoft.public.win2000.security)
  • Re: ASP Login Database to Online Form Registration
    ... If somebody wants to change his/her username, ... What I want to do is have a Login page as well as a Create ... info is validated against the database. ... student" as well as list the students' name they've already register/ ...
    (microsoft.public.inetserver.asp.db)