Results 1 to 15 of 15
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Remove username and password screen (2000)

    Is it possible to start up a database automatically without the user having to enter password and username on startup?
    I do not have a .mdw file so don't know how it can be done without this file.
    Any help would be appreciated.

    Justin.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Remove username and password screen (2000)

    You always have an .mdw file; if you haven't set a specific one, you are using the default System.mdw.

    You will be prompted to enter a username and password if a password has been set for the default Admin account. If you clear the password for Admin, you won't be prompted any more. Or you can remove or rename your System.mdw; Access will automatically create a new unsecured one.

    To clear the password for Admin:
    Select Tools | Security | User and Group Accounts.
    Make sure that Admin is selected in the Users tab.
    Click 'Clear Password'.
    Click OK.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Remove username and password screen (2000)

    Hans,

    I don't appear to be able to click on the 'Clear Password' screen.
    Any suggestions
    see attachment.

    Justin.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Remove username and password screen (2000)

    You should login as Admin. If you don't know the password for Admin, your best bet is to remove or rename the .mdw file. Since you stated that you don't have one, you are probably using the default System.mdw. I don't have Access 2000 myself, but I think System.mdw is located in C:Program FilesCommon FilesSystem. Quit Access, locate system.mdw and rename it to System.old, for example.

  5. #5
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Remove username and password screen (2000)

    I tried deleting the default .mdw file but still no luck.
    Any suggestions as to what else l could try?

    Justin.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Remove username and password screen (2000)

    1. Do you get the password prompt for all databases you open, or for a particular database?

    2. Does it matter whether you open the database from Windows Explorer or from within Access?

  7. #7
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Remove username and password screen (2000)

    In response to your questions:

    1. Only one particular database which is a shared database.

    2. Password is only prompted from when it is accessed by the shortcut and not from within Access.

    Justin.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Remove username and password screen (2000)

    OK, that makes it a lot clearer. This means that the shortcut specifies a secured .mdw to be used. You can avoid the prompt by opening the database directly instead of via the shortcut, or you can modify the shortcut as follows:

    - Right-click the shortcut.
    - Select Properties from the popup menu.
    - Activate the Shortcut tab of the Properties window (if necessary, most probably it is already the active tab).
    - Look at the Target of the shortcut. It probably looks like this (with other names, of course):

    "C:Program FilesMicrosoft OfficeOfficeMSAccess.exe" "CatabasesMyDatabase.mdb" /wrkgrp "CatabasesSecured.mdw"

    - The last part, starting with /wrkgrp specifies the workgroup.
    - Delete that part (until the end of the line).
    - Click OK.

    Try opening the database via the shortcut now.

  9. #9
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Remove username and password screen (2000)

    I tried this but still no luck,this is the line l am using for the shortcut.

    "C:Program FilesMicrosoft OfficeOfficeMSACCESS.EXE" "O:GenHUMSProject Database.mdb"

    Justin.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Remove username and password screen (2000)

    Try this then:

    - Locate the Workgroup Administrator application Wrkgadm.exe. For the US version, it is in C:Program FilesMicrosoft OfficeOffice1033, for the UK version the 1033 must probably be replaced by 2057.
    - Start this application.
    - Click Create... to create and join a new .mdw file.
    - Specify information, or leave it as suggested, then click OK.
    - You can modify the name and location, if you like, then click OK again.
    - You should now be member of a new unsecured .mdw
    - Open the database.
    - You may find that you have only limited permissions in the database.

  11. #11
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Remove username and password screen (2000)

    The problem with doing this is that it locks other users out and they are unable to use database.
    Any further suggestions?

    Justin.

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Remove username and password screen (2000)

    You would have to remove all user-level security from the database. But I assume that the person who designed this database secured it for a reason. So it is probably not desirable to do remove security. You'd better use the Workgroup Administrator again and rejoin the secured .mdw file, and live with the username/password prompt.

  13. #13
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Remove username and password screen (2000)

    When l designed it the security was done for a reason.
    I think l have no alternative but to go back to having to enter username/password.

    Thanks for your assistance.
    Justin.

  14. #14
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Remove username and password screen (2000)

    It is possible to specify the user name and password in a shortcut, so the user never sees the prompt but is logged in as the specified user. To do so use the /user and /pwd options. Search Help for the string "command line" for more details - the page you want is "Startup command-line options"
    Wendell

  15. #15
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Remove username and password screen (2000)

    Thanks for that it works.

    Justin.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •