• Remove username and password screen (2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Remove username and password screen (2000)

    Author
    Topic
    #1771571

    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.

    Viewing 0 reply threads
    Author
    Replies
    • #1815270

      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.

      • #1815272

        Hans,

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

        Justin.

        • #1815273

          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.

          • #1815274

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

            Justin.

            • #1815278

              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?

            • #1815279

              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.

            • #1815281

              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” “C:DatabasesMyDatabase.mdb” /wrkgrp “C:DatabasesSecured.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.

            • #1815282

              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.

            • #1815285

              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.

            • #1815286

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

              Justin.

            • #1815289

              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.

            • #1815290

              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.

            • #1815354

              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”

            • #1815398

              Thanks for that it works.

              Justin.

    Viewing 0 reply threads
    Reply To: Remove username and password screen (2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: