You are prompted for a username and for a password even though you do not turn on security or set up security in Access

Article translations Article translations
Article ID: 888734 - View products that this article applies to.
Expand all | Collapse all

On This Page

Symptoms

When you run Microsoft Access 2000 or a later version, you are prompted for a username and for a password. This behavior occurs even though you do not turn on security or set up security. You are prompted for a username and for a password for every database. This includes even a brand new database.

Cause

This behavior occurs if you install "Typing Tutor Deluxe" by Global Software Publishing.

Resolution

To resolve this behavior, use the Workgroup Administrator tool to rejoin the original default workgroup information file. To do this, you can use one of the following methods. The method that you use depends on your version of Access.

Office Access 2007

To use the Workgroup Administrator tool in Microsoft Office Access 2007, use Microsoft Visual Basic code. To do this, use one of the following methods.

Method 1: Run the Visual Basic code in the Immediate window

  1. In Access 2007, open a trusted database, or enable macros in the existing database.
  2. Press CTRL+G to open the Immediate window.
  3. Type the following line of code, and then press ENTER.
    DoCmd.RunCommand acCmdWorkgroupAdministrator
  4. In the Workgroup Administrator dialog box, click Join, and then click Browse.
  5. Locate and then click the following file, and then click Open:
    C:\Program Files\Common Files\system\System.mdw
  6. In the Workgroup Administrator dialog box, click OK, and then click Exit.

Method 2: Create a module that contains the Visual Basic code

  1. In Access 2007, open a trusted database, or enable macros in the existing database.
  2. On the Create tab, click Macro in the Other group, and then click Module.
  3. Create a subroutine, and then paste the following Visual Basic code in the subroutine.
    DoCmd.RunCommand acCmdWorkgroupAdministrator
  4. Press F5 to run the code.
  5. In the Workgroup Administrator dialog box, click Join, and then click Browse.
  6. Locate and then click the following file, and then click Open:
    C:\Program Files\Common Files\system\System.mdw
  7. In the Workgroup Administrator dialog box, click OK, and then click Exit.

Office Access 2003

  1. Start Office Access 2003.
  2. Click Tools, point to Security, and then click Workgroup Administrator.
  3. Click Join, click Browse, browse to C:\Documents and Settings\your user name\Application Data\Microsoft\Access\System.mdw
  4. , and then click OK.
  5. In the Workgroup Administrator dialog box, click OK.
  6. In the Workgroup Administrator dialog box, click OK.

    Note The Workgroup Administrator dialog box in step 5 is a different dialog box than the dialog box in step 4. Both dialog boxes have the same name.

Access 2002

  1. Start Access.
  2. Click Tools, point to Security, and then click Workgroup Administrator.
  3. In the Workgroup Administrator dialog box, click Join, click Browse, browse to C:\Documents and Settings\your user name\Application Data\Microsoft\Access\System.mdw, and then click OK
  4. In the Workgroup Administrator dialog box, click OK, and then click Exit.

Access 2000

  1. Click Start, and then click Search.
  2. In the Search Results dialog box, click All files and folders under What do you want to search for.
  3. Type Wrkgadm.exe under All or part of the file name, and then click Search.
  4. In the Search Results dialog box, double-click WRKGADM.
  5. In the Workgroup Administrator dialog box, click Join, click Browse, browse to C:\Program Files\Common Files\system\System.mdw, and then click OK.
  6. In the Workgroup Administrator dialog box, click OK, and then click Exit.

More information

When you install "Typing Tutor Deluxe," your workgroup security for Access is reset to point to a workgroup information file that is created for "Typing Tutor Deluxe."

References

For more information about another possible cause for this behavior, click the following article number to view the article in the Microsoft Knowledge Base:
815278 How to troubleshoot the User Authentication dialog box while opening a non-secure database

Properties

Article ID: 888734 - Last Review: July 24, 2012 - Revision: 5.0
Applies to
  • Microsoft Office Access 2007
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbdatabase kbpermissions kbpasswords kbtshoot KB888734

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com