I just converted from SQL 7 to SQL 2000 but have one issue.
My login table contains a password field that is a varbinary type. I
encrypted the value by using the encrypt('password') when inserting users
into this table.
How can I see the actual value of the password field. Is there a way to
decrypt?
For some reason, all the users passwords don't work. If I redo each one,
it
works but there are too many to redo manually.
Try this:
SELECT CAST(myPassword AS NVARCHAR(100))
FROM myTable
Where myPassword is the VARBINARY column containing the passwords.
RE: Run command on enter push ... Name and presses the enter key they will be moved to the Password field.... Enter key again and the code assigned to the OnClick event of the Login...control that you have finished your entry into that control. ... on the keyboard is pushed. ... (microsoft.public.access.modulesdaovba)
RE: Run command on enter push ... Name and presses the enter key they will be moved to the Password field.... Enter key again and the code assigned to the OnClick event of the Login...control that you have finished your entry into that control. ... on the keyboard is pushed. ... (microsoft.public.access.modulesdaovba)
Re: XP Welcome screen doesnt prompt for the users password!! ...Microsoft-MVP Windows® XP ... 2004 Windows MVP "Winny" Award ... > But now when I click on the user the password field does ... > The only way to login is to do ctrl-alt-del to get to the ... (microsoft.public.windowsxp.general)
RE: Run command on enter push ... Name and presses the enter key they will be moved to the Password field.... Enter key again and the code assigned to the OnClick event of the Login...control that you have finished your entry into that control. ... on the keyboard is pushed. ... (microsoft.public.access.modulesdaovba)
Re: Keyboard not working cannot login ... As gls858 suggested, use your mouse and click in the password field, then try typing.... If that doesn't work, try clicking OK on the login box - it should come back with something along the line of being invalid, and maybe then the login box will activate and let you type in it. ... The reader should exercise normal caution and backup the Registry and data files regularly, and especially before making any changes to their PC, as well as performing regular virus and spyware scans. ... (microsoft.public.windowsxp.basics)
