Change default Password

[jonamua1971]

Hi
i followed the link below
http://support.microsoft.com/kb/179371 and was successful to put the password on my form. my question is how do i change the default password
to my own. i have tried but failed.
Any help will highly aprreciated

 

[The_Doc_Man]

OK, I followed the link. Default passwords should NEVER match another valid password on your system. If we talk about "best practises" that implies there is a scale of good and bad things. Making a default password match a valid password is probably somewhere nearer the "worst practises" end of the scale.

Having said that, the item in question is merely table driven, and the keycode you would enter is a field in a table. For which it is possible to assert a default value at the field level in the table's definition. You should be able to open the table in design mode, select the field that contains the key code, and put in a non-blank default value. This won't affect already-defined codes, but any new entries would start life with the new default value.

 

[mikebaldam]

simple password on form

If you're just looking to have a simple password box to open a form...

try

'VB Password Box 


Private Sub PassCheck_GotFocus() 
Dim strInput As String, strMsg As String 

strMsg = "Enter password." 
strInput = InputBox(Prompt:=strMsg, Title:="Password", XPos:=2000, YPos:=2000) 

If strInput = "YOURPASSWORD" Then 'YOURPASSWORD -### change 

MsgBox "Hello, " 
Responsibility.Locked = False 
Else 
MsgBox " incorrect" 
Responsibility.Locked = True 
'NoEntry 
End If 

End Sub

Its not very secure but a very easy way of prompting for a password to open a form... ... but if any one has access to the VB code they can just read the password... but after saying that its nice n easy

 

[jonamua1971]

thank you very much for all the responses.