Overriding file associations

  • Thread starter Thread starter Ross Luker
  • Start date Start date
R

Ross Luker

Hi,

I have PCs with WinXP Pro and Office XP installed as standard.
However, we have an Access .mdb application which requires Access 2000
(2002 trashes it). The problem is that the mdb is launched from
within our ERP package, so there's no chance of using "Open As...",
and the ERP system seems to launch the app using the Windows default
file association. Is there a way that I can tell Windows to only open
that particular mdb with Access 2k, while leaving all others to Access
2k2? I do still need to keep Access 2k2 as well...

TIA

Ross
 
Ross said:
Hi,

I have PCs with WinXP Pro and Office XP installed as standard.
However, we have an Access .mdb application which requires Access 2000
(2002 trashes it). The problem is that the mdb is launched from
within our ERP package, so there's no chance of using "Open As...",
and the ERP system seems to launch the app using the Windows default
file association. Is there a way that I can tell Windows to only open
that particular mdb with Access 2k, while leaving all others to Access
2k2? I do still need to keep Access 2k2 as well...
Click to expand...

Find that particular .mdb file in Explorer. Highlight it. Right click it
and choose "open with". Find your Access 2000 program and choose that.
Don't put a checkmark before "always use this program to open this type
file" if you intend to open other .mdb files from Explorer using 2002. But
if you will always open the other files by opening 2002 itself and choosing
the files you could go ahead and put the check mark there. That way
doubleclicking that .mdb file from Explorer would always use Access 2000,
whereas all the other files would be opened from within your Access 2002
program and you would be using 2002.
 
We had a similar problem with needing Access 97 for a 3rd party database
and having Office 2k installed. If memory serves me what we did was like
this (with version changes according to your situation):

Find and rename MSACCESS.EXE to ACCESSXP.EXE (or something)
Make a shortcut to the renamed file in your Programs menu (so you can
still use Access 2002 that way).

Install ONLY Access 2000 from the Office 2000 cd.

Now when your ERP package opens it will find MSACCESS.EXE but it will be
Access 2000 executable.

Steve
 
Back
Top