Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi all,

    Lately some of my clients have been experiencing problems with their MS Access application shortcuts. The clients have been upgraded from MS Access 2002, where all the shortcuts worked well. Now the shortcuts will not work. They can be clicked, but nothing happens. This is a random problem I am experiencing and it is rather annoying. Any and all suggestions are welcome. TIA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Have you checked the target of the shortcuts? If they still point to the folder where Access 2002 used to be installed, they won't work with Access 2007...

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='800540' date='29-Oct-2009 17:00']Have you checked the target of the shortcuts? If they still point to the folder where Access 2002 used to be installed, they won't work with Access 2007...[/quote]

    Thanks, Hans. I'll give that a try and let you know.

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by BCKessinger View Post
    Thanks, Hans. I'll give that a try and let you know.
    Okay, the shortcut targets were fine. Some additional info on this. If I 2x the .mdb, nothing happens; If I begin MSAccess.exe, then open the .mdb, all is fine. Any other thoughts. This doesn't happen on all my client's computers.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    If a user can open a database from within Access but not from Windows Explorer, the file association for the .mdb extension is not correct.

    Can they do the following?

    • Right-click the .mdb file in Windows Explorer.
    • Select Open With > Choose (Default) Program... from the popup menu.
    • Point to Microsoft Office Access.
    • Tick the check box "Always use this program to open this kind of file".
    • Click OK.

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    Quote Originally Posted by BCKessinger View Post
    Okay, the shortcut targets were fine. Some additional info on this. If I 2x the .mdb, nothing happens; If I begin MSAccess.exe, then open the .mdb, all is fine. Any other thoughts. This doesn't happen on all my client's computers.
    I've seen this before. Sometimes it is caused by a "phantom" instance of Access still being in memory. With the database closed, open the Task Manager and look at the Processes tab. See if there is an instance of Access listed; if so, select it and click the "End Process" button.

    Not so convenient is to change your shortcuts. Rather than directly point to the database (and then have Windows select how to open the file), change your shortcut so it opens Access, something like this:

    "C:\program files\Microsoft Office\msaccess.exe" "c:\myfiles\mydb.mdb"
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  7. #7
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Hans and Mark. I'll try these Monday when I get back to work.

  8. #8
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by BCKessinger View Post
    Thanks Hans and Mark. I'll try these Monday when I get back to work.
    Changing the shortcut to open Access seemed to be the best solution, i.e.,

    "C:\program files\Microsoft Office\Office12\msaccess.exe" "c:\myfiles\mydb.mdb"

    Thanks for all the suggestions

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •