It would I think be difficult and I have to ask why you want to do this anyway.
If you want to restrict the form to certain individuals then do some/all of the following
1. Hide the navigation pane so users can only open objects via command buttons on forms - this is a good idea anyway.
2. Assign your users to different groups and limit the access to certain items by user group. If you want you can still use a password to make it more secure but use the same password for all authorised users
3. Consider hiding or disabling the buttons to open those forms to no-authorised users
4. Disable Access options so users can't undo those settings
Some very basic code for password protecting your form
Code:
Private Sub Form_Load()
Dim PassWord As String
PassWord = InputBox(“Enter Password”)
If PassWord = “whatever password you choose here” Then 'open form
DoCmd.OpenForm “name of the form that you want to password protect”
ElseMsgBox (“Wrong Password?”)
DoCmd.Close acForm, Me.Name
End If
End Sub
Note that the above isn't particularly secure not least because the input box entry isn't masked
I do have code for a masked input box at http://www.mendipdatasystems.co.uk/m...box/4594462216
There are many other security measures you could add if you want to make your app as secure as possible