Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am running Windows 7 x64. I have a file type that I want to associate with Microsoft Access 2003.

I right-click on the file and select Open With->Choose Default program. In the "Open With" dialog, I select the browse button. I choose Program Files (x86)\Microsoft Office\Office11\msaccess.exe and press "Open".

I end up back at the "Open With" dialog, but nothing has changed. Access is not listed as a program to use to open the file with. The original program (Adobe Acrobat) that is associated with this program is still selected.

Any tips on getting this association to work?

share|improve this question
    
Yes, this is a bizarre bug that has annoyed me for a long time and several versions of Windows. It only happens intermittently so I have not kept track of which executables exhibit/trigger this behavior, thus I have been unable to find any sort of unique commonality between them. –  Synetech Jul 16 '12 at 20:20
add comment

5 Answers

up vote 2 down vote accepted

If all fails, you can edit the registry manually (backup the the hive/key first):

Each file type (extension) which has an associated application has a Registry key under HKEY_CLASSES_ROOT.

Or use FileAsoc, a Windows File Association Editor

FileAsoc is open source freeware.

Or File Type Doctor, which is part of the Creative Element Power Tools (shareware)

alt text

share|improve this answer
    
Thanks, I was able to use the File Type Doctor in the Create Elements Power Tools to get the association fixed. –  David Robison Jan 5 '10 at 18:32
    
you're most welcome. –  Molly7244 Jan 5 '10 at 18:39
    
They way to change this via registry is indicated in another answer here –  sancho.s Nov 29 '13 at 18:13
add comment

The registry key shown above was my problem.

HKEY_CLASSES_ROOT\Applications\MSACCESS.EXE\shell\open\command

Should read:

"C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" "%1"

for access 2010.

It still had the entry:

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "%1"  

for office 2007.

The file does not exist in that location so it did not appear in the application selector until I changed the entry.

Once I updated the registry I was ableto select Microsoft Access directly from the list of available applications.

share|improve this answer
add comment

The cause is most likely a quirk in the registry that slipped in for some unknown reason.

Make sure the key value in the following location contains the correct path:

HKEY_CLASSES_ROOT\Applications\YOURFILE.EXE\shell\open\command

Search for the application name and the file extension in the registry to see if other entries are possibly corrupted as well.

share|improve this answer
1  
This was exactly the issue for me.. once I changed the value at that exact location, it worked fine as soon as I tried to browse -> open again –  abelito Nov 19 '12 at 15:03
    
When the key value does not point to the right location of the application, change it as indicated in another answer here –  sancho.s Nov 29 '13 at 18:11
add comment

I have seen cases where some dialogs don't prompt you for security elevation and do not give you a message that the change could not be made. Try doing it through control panel

Control Panel -> Programs -> Default Programs -> Set Associations

Or just type "file open" into the start menu search and choose "Make a file type always open with a certain program"

share|improve this answer
add comment

I recently had a similar problem with all of my media file associations, and it seemed due to an obnoxious media player called DAPlayer. Even under Control Panel/Programs/Default Programs/Set Default Programs, I was unable to change the default program. Apparently, it set the UserChoice keys under HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts for all of its file associations to read-only access, even for administrators. Even after uninstalling the program, all of my associations remained stuck on "Unknown Application".

The simplest way to fix this is to browse to that key in Regedit, right-click it and select Permissions, click the Advanced button, check "Replace all child object permissions", and click OK.

Or if you prefer the command line, you can use a Windows Resource Kit tool called SubInACL:

subinacl /subkeyreg HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts /grant=administrators=f /grant=system=f /grant="%USERNAME%"=f

But be careful with bulk registry operations like this: improper use could render your system inoperable! I take no responsibility for your actions.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.