Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2003
    Location
    London, Gtr London, England
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2000 Desktop Shortcut defaulting to 97 (2000)

    Hi there!

    I have a user in our organisation who has sought me out re a problem that has just occurred re launching a 2000 DB from his desktop.

    He drags this DB from an FTP link to his desktop and double clicks on it to open it up. He has both 2000 and 97 installed on his PC and today it has decided to try and launch unsuccessfully as 97 instead of 2000. I have removed the 97 desktop icon and renamed the .exe file to stop 97 from launching, but the copied DB still thinks it is 97, when double clicked on the desktop. The DB will open if 2000 is launched first and subsequently opened from within. A fix I have put in place is a 2000 shortcut with the path of the DB in the target.

    The user is uncomfortable with this (although it works perfectly!) and just wants to drag and drop and double click to go.

    I don't have rights to uninstall 97, that has to be performed by the powers that be here after several millenia and forests worth of forms have been completed.

    Does anyone know how I can get the desktop to default to 2000? I'm sure I've seen this before and all I had to do was launch 2000 to get Access to remember which version it had used last. It's not working in this instance though...................

    Cheers,

    Niven

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 2000 Desktop Shortcut defaulting to 97 (2000)

    According to Microsoft (Description of how to run multiple versions of Microsoft Access with Access 2003:
    <hr>When you double-click an Access database file in Windows Explorer, or when you click an Access database file from the Recent Documents folder in Windows, the following rules apply:<UL><LI>If a version of Access is running, the Access database file opens in that version.
    <LI>If no version of Access is running, the Access database file opens in the version of Access that you most recently installed on your computer or in the version of Access that you last used on your computer. Every time that you start Access, Access registers itself as the version to load the Access database file with.[/list]<hr>
    This should apply to Access 97 and 2000 on one computer too, but apparently it doesn't. Can you edit the file association for .MDB on the problem PC (Windows Explorer, Tools | Folder Options..., File Types tab), and if so, does it help if you associate it with Access 2000?

  3. #3
    3 Star Lounger
    Join Date
    Nov 2003
    Location
    London, Gtr London, England
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 Desktop Shortcut defaulting to 97 (2000)

    Aha!

    The file association in the Explorer, Tools | Folder Options..., File Types tab did the trick. It was pointing to the old 97 version. Changing it to 2000 has solved the problem. I had tried associating the 2000 version from the .MDB desktop icon by using Open With, but that didn't work.

    Cheers, <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

    Niven

Posting Permissions

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