Security? Not Sure

[cowboyfett]

I am making a database to track skills for an educational program. For a given skill, i want to record the date and have the instructor put in a password to "sign" the skill. It could be a simple typed out name, but have it be password protected. Is that possible in access?

[pbaldy]

One way:

Private Sub Odometer_BeforeUpdate(Cancel As Integer)
  Dim strTypePass As String

  strTypePass = InputBox(prompt:="Enter Password")
  
  If Not strTypePass = g_sOdoPass Then
    Cancel = True
  End If

End Sub

In this case g_sOdoPass is a global constant holding the password. You can add an Else clause with a message box "incorrect password" or whatever.