Microsoft KB Archive/287448

= Access 2002 runtime is the default file association for .mdb database files and for .adp project files =

Article ID: 287448

Article Last Modified on 8/19/2004

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q287448



SYMPTOMS
After you install a run-time version of Microsoft Access 2002 on a computer that has Microsoft Access 2000 or an earlier version installed, if you use Windows Explorer or a shortcut to open a file that was created in Access 2000 or in an earlier version, the file opens in the newly installed Access 2002 run-time environment.



CAUSE
Access 2002 was either just installed or was the last version of Access that you ran on this computer. Because Access files share the same file extensions between versions, only one version of Access can be registered on the computer at any one time as the default file association for .mdb and .adp files. When you start Access 97, Access 2000, or Access 2002, including run-time installations, the version being started registers itself as the default file association for Access files.



RESOLUTION
There are two ways to work around this behavior:  Always open the correct version of Access before you open a specific file.

-or- Use a shortcut to open a file that specifies the version of Access to use. To do so, follow these steps:  Use Windows Explorer to locate the file that you want to open. Right-click the file, and then click Create Shortcut. Right-click the shortcut, and then click Properties. Change the path to point to the version of Msaccess.exe that you want to use with this file by using syntax similar to the following:

&quot;C:\Program Files\Microsoft Office\Office\MSACCESS.EXE&quot; &quot;C:\ \YourFileName.mdb&quot;

</li> Click OK.</li> Double-click the shortcut. Note that the file opens in the version of Access that you specified in the Target property of the shortcut.</li></ol> </li></ul>

<div class="status_section">

STATUS
This behavior is by design.

<div class="moreinformation_section">

Steps to Reproduce the Behavior

 * 1) In Access 2000, create and then save a new database.
 * 2) Install an Access 2002 run-time application that was created by using the Microsoft Office XP Developer Packaging Wizard.
 * 3) Start the run-time application and verify that it works. Close the run-time application.
 * 4) Use Windows Explorer to find the file that you installed in step 2.
 * 5) Double-click the file to open it. Note that the file opens in the Access 2002 run-time environment.

<div class="references_section">