MartyConnelly
martyconnelly at shaw.ca
Thu Jun 7 11:54:24 CDT 2007
Ahh this method works with right click file name and then "Open With" rather than "Send To" Charlotte Foust wrote: >I have individual send tos already. They work for the other versions, >but for 2007, they open 2007 but not the document I'm sending to it. >I'll have to check the shortcut for 2007 to see if there's something >wrong with it, but I don't know what it would be. > >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 7:09 PM >To: Access Developers discussion and problem solving >Subject: Re: [AccessD] turing off auto detect andrepair whenmultiple >accesversion > >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 >> >> >>> <> year and a day to "configure" itself again! So much for backward *or* >> >>>forward compatibility! >>> >>>Charlotte Foust >>> >>> -- Marty Connelly Victoria, B.C. Canada