Disable AllowByPass Property

[Kathy Atchley]

In Access 2000, I need to disable the AllowByPass
property. I don't want people pressing Shift to get
behind my database. I have found articles saying to use
an AutoExec macro, but the shift key will bypass the
macro. I also saw an article for code, but am unsure
where to put the code so the Shift key won't bypass it.
Any insight on this would be great. Thank you. Kathy

 

[Kathy Atchley]

I appologize for the dumb question but how do you time out
a form? I have the splash form, the timer is set, but I
don't know the command to time out the form. I
tried "Idle" but nothing happened. Thanks for your help.
Kathy

 

[John Spencer (MVP)]

In the On Timer event add a line that closes the form.

Assuming that you have set the timer Interval to 4000 (4 seconds), then in the
On Timer Event

Select [Event Procedure];
Click on the three dot button at the end
Enter the code below (Access will have built the first and last line)


Private Sub Form_Timer()
DoCmd.Close acForm, Me.Name
End Sub

That should do it. The form will display for four seconds and then close. If
you want another form to open, then add the code for that in the code above.

DoCmd.OpenForm "YourOtherFormName"

 

[Bruce M. Thompson]

Make sure that you *FIRST* make and keep a copy of your database that has not
had the "AllowByPassKey" property modified or you may not be able to make future
changes to your application.