Microsoft KB Archive/888734

= 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 ID: 888734

Article Last Modified on 12/28/2006

-

APPLIES TO


 * Microsoft Office Access 2007
 * Microsoft Office Access 2003
 * Microsoft Access 2002 Standard Edition
 * Microsoft Access 2000 Standard Edition

-



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 &quot;Typing Tutor Deluxe&quot; 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
 In Access 2007, open a trusted database, or enable macros in the existing database. Press CTRL+G to open the Immediate window.  Type the following line of code, and then press ENTER. DoCmd.RunCommand acCmdWorkgroupAdministrator  In the Workgroup Administrator dialog box, click Join, and then click Browse. Locate and then click the following file, and then click Open:

C:\Program Files\Common Files\system\System.mdw

 In the Workgroup Administrator dialog box, click OK, and then click Exit.</ol>

Method 2: Create a module that contains the Visual Basic code
<ol> In Access 2007, open a trusted database, or enable macros in the existing database.</li> On the Create tab, click Macro in the Other group, and then click Module.</li>  Create a subroutine, and then paste the following Visual Basic code in the subroutine. DoCmd.RunCommand acCmdWorkgroupAdministrator </li> Press F5 to run the code.</li> In the Workgroup Administrator dialog box, click Join, and then click Browse.</li> Locate and then click the following file, and then click Open:

C:\Program Files\Common Files\system\System.mdw

</li> In the Workgroup Administrator dialog box, click OK, and then click Exit.</li></ol>

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\ \Application Data\Microsoft\Access\System.mdw
 * , and then click OK.
 * 1) In the Workgroup Administrator dialog box, click OK.
 * 2) 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\ \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.

<div class="moreinformation_section">

MORE INFORMATION
When you install &quot;Typing Tutor Deluxe,&quot; your workgroup security for Access is reset to point to a workgroup information file that is created for &quot;Typing Tutor Deluxe.&quot;

For more information about &quot;Typing Tutor Deluxe,&quot; visit the following Global Software Publishing Web site:

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

<div class="references_section">