Microsoft KB Archive/132707

= Customized Setting For Access Reverts Back to Original =

Article ID: 132707

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 1.0 Standard Edition
 * Microsoft Systems Management Server 1.1 Standard Edition

-



This article was previously published under Q132707





SYMPTOMS
After you distribute a package with Systems Management Server containing Microsoft Access 2.0, customize the toolbar settings, and exit and restart Access, the customized toolbar settings are not available. PGC resets the Access toolbar settings every time Access runs.



CAUSE
This problem occurs if the SystemDB entry in MSACC20.INI points to the SYSTEM.MDA file on the distribution server. Even after you manually change the entry to point to the local SYSTEM.MDA file (which contains the customized toolbar settings), the entry is changed automatically to point to the SYSTEM.MDA file on the distribution server when you run Access.



WORKAROUND
To work around this problem:

  Modify the SMSSHARE.STF file in the SMSPROXY subdirectory of the Microsoft Access package directory on the Systems Management Server (distribution server). Change:      %s\system.mda                  (line 88) %s\workdir\system.mda         (line 89) %s\system.mda                 (line 761) to:      %1\system.mda                  (for all three lines)   In the MSACC20.INI file, change the SystemDB entry to:      [Options] SystemDB= :\ACCESS\SYSTEM.MDA   Do one of the following, depending on the network operating system your client computer is using:

Windows NT Client
WARNING: Using Registry Editor incorrectly can cause serious, system- wide problems that may require you to reinstall Windows NT to correct them. Microsoft cannot guarantee that any problems resulting from the use of Registry Editor can be solved. Use this tool at your own risk.

 Run Registry Editor (REGEDT32.EXE).</li>  From the HKEY_CLASSES_ROOT subtree, go to the following subkey: <pre class="fixed_text">        \SMS\Applications\msaccess\DAEE\Profile0 </li> Remove the [Options][SystemDB] entry.

NOTE: A Microsoft Test script, distributed as a PCM job, can remove the Registry entry each time Microsoft Access runs.</li> Quit Registry Editor.</li></ol>

Windows for Workgroups 3.11 Client
<ol style="list-style-type: lower-alpha;">  Run the Registration Info Editor (REGEDIT.EXE) with the following command: <pre class="fixed_text">        REGEDIT /V </li>  Go to the following subkey: <pre class="fixed_text">        \SMS\Applications\msaccess\DAEE\Profile0 </li> Remove the [Options][SystemDB] entry.</li> Quit REGEDIT.EXE.</li></ol> </li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed this to be a problem in Systems Management Server versions 1.0 and 1.1. We are researching this problem and will post new information in the Microsoft Knowledge Base as it becomes available.

Additional query words: prodsms wfw wfwg

Keywords: kbnetwork kbpgc KB132707

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.