Here is a Microsoft article on the issue:
http://support.microsoft.com/kb/321305
since there is another user on the system who does have access, one way would be for that person to logon, go to ControlPanel/UserAccounts and delete the user with the forgotten password, then create a new account, and if you choose to password it, write that down someplace where you remember where you put it.
