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


The information in this article applies to:

  • Microsoft Office Access 2003
  • Microsoft Access 2002
  • Microsoft Access 2000

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.

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.

Access 2002

  1. Start Microsoft 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.

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.

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."

For additional information about "Typing Tutor Deluxe," visit the following Global Software Publishing Web site:

http://www.gsp.cc/index.html

REFERENCES

For additional 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

Modification Type:MajorLast Reviewed:12/21/2004
Keywords:kbDatabase kbpermissions kbpasswords kbtshoot kbbug KB888734 kbAudDeveloper kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.