[AccessD] turing off auto detect and repair whenmultiple accesversion

MartyConnelly martyconnelly at shaw.ca
Wed Jun 6 21:09:28 CDT 2007


Are you perhaps missing the %1 at the end of the path name?

1. Start Windows Explorer,
2. Select Tools and then Folder Options...
3. Click on the File Types Tab
4. Find the MDB file type
5. Click Advanced
6. Chances are there are 2 options.  Open in bold font (denoting default)
   and New.  You can pretty much add what you want here.  For decompile,
7. Click New
8. Under action type Decompile
9. Under Application used to perform action type the equivalent for your
   install:
  "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" /decompile "%1"
10 Click OK and exit out

And wallah!  You now right click an mdb and have the context option of
decompiling it.

But it doesn't stop there.  For those of us juggling multiple versions of
Access you can setup a right click option to open in each.
Eg
Open in 97
Open in 2000
Open in XP

And make sure the path points to the correct version of access.
Have all your Access paths available in a notepad file so you can cut 
and paste
as this has to be done in one pass, editing afterwards is difficult
 
----------------------------------------

There is another way via the registry but the full moon has just passed
and I don't have any spare chickens. Also I haven't used since Access 2.0
and Win 95, so I am unsure of Win XP registry keys.

To accomplish this do the following:

    # Make sure you have a back up copy of your registry, in case of an 
error.
    # Open the Registry Editor, and under the key "Hkey_Classes_Root", 
where X = the highest version of Access you have installed
    # Under this Access.Application.X key click on the "Shell" key and 
then select "Edit" from the menu, "New", then "Key". After the key is 
added, name this key "Open with Access X." Where X is the version you 
want to add.
    # Highlight the new key and repeat the process in item 3 to add 
another new key below "Open with Access X" and name this key "Command".
    # Click on the new "Default" entry in the "Command" key and key 
value dialog will be displayed. Enter the path to the version of Access 
2 on the computer, appending a "%1" at the end. Example: 
"C:\Access\msaccess.exe %1"

You should now have the option to open any access database on your 
system with any version of Access when right clicking in Windows Explorer.

Charlotte Foust wrote:

>I have all three installed too.  However, since my 2007 installation, I
>haven't been able to get the Open With to work properly.  It opens the
>application (after any delays it deems necessary) but not the file I
>started from.  Maddening in Word, Excel and, yes, Access.
>
>Charlotte Foust 
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
>Sent: Wednesday, June 06, 2007 10:52 AM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] turing off auto detect and repair whenmultiple
>accesversion
>
>I have Access 97, 2003 and 2007 installed If I use the right click "open
>with" method on the mdb to select which version to use to open, it takes
>10-15 seconds to start up.
>The only problem being the icons are the same for 2003 and 2007 It
>rotates the last used version icon to the top of the open with stack.
>
>
>Charlotte Foust wrote:
>
>  
>
>>Office 2007 does NOT like to coexist with earlier versions.  I don't
>>know how to turn it off either.  My pet peeve is that if I use A2003,
>>    
>>
>it
>  
>
>>runs the msi briefly to "install" O2003.  If I then run 2007, it takes
>>    
>>
>a
>  
>
>>year and a day to "configure" itself again!  So much for backward *or*
>>forward compatibility!
>>
>>Charlotte Foust 
>>
>>-----Original Message-----
>>From: accessd-bounces at databaseadvisors.com
>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps
>>    
>>
>-
>  
>
>>IT Helps
>>Sent: Wednesday, June 06, 2007 7:13 AM
>>To: Access Developers discussion and problem solving
>>Subject: [AccessD] turing off auto detect and repair when multiple
>>accesversion
>>
>>Hi Group
>>
>>Since I installed MSO2K7 on my computer, the detect and repair function
>>tries to repair my office when I switched back and forth MSO2K3    and
>>MSO2K7.
>>
>>Does anyone know how to turn this off?
>>
>>
>>
>>Erwin Craps
>>
>>Zaakvoerder 
>>
>>
>>
>>Nieuwe internetwinkel op www.ithelps.be/shop
>><http://www.ithelps.be/shop> 
>>
>>www.ithelps.be/onsgezin
>>
>>bezoek ook eens de website van mijn zus www.friedacraps.be
>><http://www.friedacraps.be/> 
>>
>>
>>
>>This E-mail is confidential, may be legally privileged, and is for the
>>intended recipient only. Access, disclosure, copying, distribution, or
>>reliance on any of it by anyone else is prohibited and may be a
>>    
>>
>criminal
>  
>
>>offence. Please delete if obtained in error and E-mail confirmation to
>>the sender.
>>
>>IT Helps - I.T. Help Center  ***  Box Office Belgium & Luxembourg
>>
>>www.ithelps.be <http://www.ithelps.be/>   *  www.boxoffice.be
>><http://www.boxoffice.be/>   *  www.stadleuven.be
>><http://www.stadleuven.be/> 
>>
>>IT Helps bvba* ** Mercatorpad 3 **  3000 Leuven
>>
>>IT Helps  *  Phone: +32 16 296 404  *  Fax: +32 16 296 405 E-mail:
>>Info at ithelps.be 
>>
>>Box Office **  Fax: +32 16 296 406 **  Box Office E-mail:
>>Staff at boxoffice.be <mailto:figures at boxoffice.be> 
>>
>>
>>--
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>
>> 
>>
>>    
>>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada




More information about the AccessD mailing list