Window Server 2003 File Association

I accidentally associated dbf files on my windows server 2003 system to excel.  It used to be associated with windows shell common.  How do I reset it
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Paul SauvéRetiredCommented:
If you right-click the file and select Open With, you can reset the default program...
 Right-click on file icon
Pardon my O/S, it's in French :-)
In Windows 2000 and Windows Server 2003, information stored in the HKEY_LOCAL_MACHINE\SOFTWARE\Classes registry key still contains global file type associations that are global to all users of the computer. However, entries that reside in the HKEY_CURRENT_USER\SOFTWARE\Classes registry key take precedence in the event of a duplication.

The user interface (UI) still points to the global settings in the HKEY_LOCAL_MACHINE\SOFTWARE\Classes registry key. In addition, security is changed so that only members of the Administrators or Power Users group have permissions to this dialog box. This affects workstations, servers, and servers in Remote Administration mode.

On computers running Windows 2000 Terminal Services in Application Server mode, the UI may be locked down so that no one can change file type associations (not even administrators). This is done so that you can only edit the entries programmatically or by using MSI-based applications. This ensures that an inadvertent change in the UI does not effect the global file type associations across the computer running Terminal Services and all of its users. When this policy is enabled, the New, Delete, Change, and Advanced buttons are unavailable on the File Types tab of the Folder Options tool in Control Panel.

You can enable this functionality by changing the following registry entry:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\Explorer] "NoFileAssociate"=dword:00000000
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756  ( ) How to back up and restore the registry in Windows
Changing this key from its default value of 00000001 enables the File Types dialog box to function just as it does for other Windows 2000 configurations. Administrators and Power Users can change the global file type settings for the computer and all of its users.

Currently, there is no way through the UI to change or edit the user-specific file type associations stored in the HKEY_CURRENT_USER\SOFTWARE\Classes registry key. If you want to do this, you have to directly edit the registry or develop your own UI to gain access to this information.

For more information, search on HKEY_CLASSES_ROOT in the Technical Reference to the Windows 2000 Registry in the Microsoft Windows 2000 Resource Kit.

Open in new window

grillmannAuthor Commented:
I need to reset it to windows shell common dll.  Anyone know how to do that?
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Set the association to - C:\windows\system32\shell32.dll in the standard file association GUI.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Why shell common? Is this not a dBase or Lotus Approach file?
grillmannAuthor Commented:
Discovered the program (Cougar Mountain) doesn't mind the file association.  So I can edit the dbf files with excel when I need to.  thanks for your replys.  I split the points amongs you all
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Legacy OS

From novice to tech pro — start learning today.