File Association

[PaulO]

I have installed a Runtime 2007 application on a user computer, but the computer's file associations appear to be missing/incorrect.

How and where do I change the file association for this .accdr file?

Where does the MS Access Runtime file actually get installed ... and should I be pointing the .accdr file at this?

Any advice greatly appreciated.

 

[PaulO]

I found this on an Internet search ...

Hit Start-->Run and type the command-line switch below into the box and hit Enter (or click OK). Note that there is a space before the slash:​

msaccess /regserver

or maybe it should be

msaccess.exe /regserver

Anyone know whether this is worth trying or avoiding?

 

[vbaInet]

For file association you need to execute the assoc command in command prompt. You can use the Shell() function to do so. Why do you think it's a file association problem though?

 

[PaulO]

The program wouldn't open for the user ... by the time I got to the user they'd opened the file Properties and associated MS Works to the file !

So, I'm perhaps trying to unstitch a user-created problem ...

Using the assoc command, then, what else do I type in?

 

[vbaInet]

assoc is not a VBA command, it's a command prompt command. Have a look online for syntax, I don't remember the exact syntax.

So go back to the user's machine, right-click an Access file, select Open-With and re-associate the file with Access.

 

[PaulO]

So go back to the user's machine, right-click an Access file, select Open-With and re-associate the file with Access.

I tried exactly that last night without success ... even though I found an MSACCESS.exe file in the Office12 folder ... I double-clicked and/or opened the MSACCESS.exe file but the new association wouldn't change?

 

[vbaInet]

Right then, assoc it.

 

[PaulO]

Tested assoc and .accdr did have a correct-looking association!

So, next I created a desktop shortcut that does seems to work:-

Target = "C:\Program Files (x86)\Microsoft Office\Office12\MSACCESS.EXE" C:\Folder\File.accdr

Start in = "C:\Program Files (x86)\Microsoft Office\Office12"

Pleased with the result, but still concerned that I couldn't simply change the program to open the file with in the File Properties ...

 

[vbaInet]

Maybe you forgot to tick the Default box.

 

[PaulO]

Maybe you forgot to tick the Default box.

No, did that, hence why I'm still puzzled ...

 

[vbaInet]

Goes to show that GUI isn't always the best.