Password Help

C

Caleb

I was wondering if it was possible to password protect a single column in a
database?
 
B

Brian

I think table-level security is as far as Access inherent security goes. What
you can do is to discourage your users from opening the tables directly (by
not showing the database window, by creating a separate front end, etc.), and
then (on your form used to edit the records that involve this field) require
a password to unlock and/or enable the control that is bound to that field.
For example, you could put this on a button:

Private Sub ButtonUnlock_Click()
If InputBox "Please enter password" = "12345" Then
Text1.Enabled = True
Else
Text1.Enabled = False
End Sub

Private Sub Form_Open (Cancel As Integer)
Text1.Enabled = False
End Sub
 
Top