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?
TAWpowerConnect With a Mentor Commented:
Set the association to - C:\windows\system32\shell32.dll in the standard file association GUI.

Paul SauvéConnect With a Mentor 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 :-)
TAWpowerConnect With a Mentor Commented:
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

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

grillmannAuthor Commented:
I need to reset it to windows shell common dll.  Anyone know how to do that?
FireW0lfConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.