ms access password problem..

Discussion in 'Windows Desktop Systems' started by GoNz0, May 13, 2004.

  1. GoNz0

    GoNz0 NTFS Stoner

    Messages:
    2,781
    Location:
    the year 2525
    right i have a friend with a small problem, he was doing his coursework for school, some form of database, and it came to the password part, instead of passwording the file in question he managed to password access on his user account (admin rights), ok so he screwed his password even tho' he confirmed it. so far the workaround is to log in using other family members accounts and he can open any document without the password prompt.

    my question is, how can i reset it to not require a password when he uses his account, would a uninstall/reinstall reset the password status, like i say the guy is admin on his own pc, so he can reinstall no probs. will it work though ?

    or can anybody shed any light on this for me please, we don't want to have to recreate his user account as it has loads of info there.. :(
     
  2. bush dogg

    bush dogg OSNN Senior Addict Political User

    Messages:
    433
    Location:
    Kansas
    This may help

    To complete this procedure, you must be logged on as a member of the Admins group.

    Start Microsoft Access by using the workgroup information file in which the user account is stored.
    You can find out which workgroup information file is current or change workgroups by using the Workgroup Administrator.

    Open a database.
    On the Tools menu, point to Security, and then click User and Group Accounts.
    On the Users tab, enter the user account name in the Name box.
    Click Clear Password.
    Repeat steps 4 and 5 to clear any additional passwords, and then click OK when you have finished.
     
  3. Mainframeguy

    Mainframeguy Debiant by way of Ubuntu Folding Team

    Messages:
    3,763
    Location:
    London, UK
    I have a simpler idea - just start in Safe Mode and you should be able to get into the default Administrator accoutn and then reset his password or remove it. I take it his account was not the default Admin account? If it was then a lesson learnt maybe?
     
  4. GoNz0

    GoNz0 NTFS Stoner

    Messages:
    2,781
    Location:
    the year 2525
    thanks i e-mailed that too him, will let you know.
     
  5. GoNz0

    GoNz0 NTFS Stoner

    Messages:
    2,781
    Location:
    the year 2525
    no Administrator is the default account for XP :rolleyes: thanks anyway MFG, i will see what happens.