[AccessD] Access 2002 overides A97 as default app

Jim,

There are several ways to solve the problem that there is only one file
extension (.mdb) that has to be shared among the various versions of
Access.  The way I solve it is to create shortcuts for each of my apps
that include the path to the correct version of Access to open that app
with.  For my A02 apps the shortcut looks as such:
"C:\Program Files\Microsoft Office\Office10\Msaccess.exe" /wrkgrp "Path
to proper MDW for app" "Path to application" in that order.

First you tell it where to find the proper version of Access to use,
then you tell it where to find the proper workgroup file to control
permissions if you are not using the default System.mdw, and finally you
tell it where to find the application.  Once I have set up all the
shortcuts I never have to worry about them until something gets moved or
converted.  The only problem with this technique is you have to train
yourself to never double-click on the app, always double-click on the
shortcut.  But if you have enough brains to be an Access developer, this
should be easy.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Jim DeMarco [mailto:Jdemarco at hshhp.org] 
Sent: Wednesday 2003 Mar 26 09:16
To: AccessD (E-mail)
Subject: [AccessD] Access 2002 overides A97 as default app

We just installed Access 2002 for a project but now anytime we open and
mdb it opens in the newer version.  I tried changing the association in
the properties window (Win 2K) but it didn't work.  How can I reset the
default application for mdbs to A97?

Thanks,

Jim DeMarco
Director of Product Development
HealthSource/Hudson Health Plan