Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Belfast, Antrim, Ireland, Northern
    Thanked 0 Times in 0 Posts

    Having access 97 & 2000 on one PC (MSAccess)

    Does anyone know hopw I can install both Access 97 (onits own) and Access 2000 (along with the rest of the MSOffice 2000 suite) onto onto the same Windows 2000 PC??
    I am able to load both, but when I set Access 97 as the default program for .mdb files, not all my databases open with Access 97 or there is an error message
    Anyone know of how I can choose which Access I use to open with which database?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Having access 97 & 2000 on one PC (MSAccess)

    When you install different versions of Access on the same PC, the last version you used will be the one used when you open a database from Windows Explorer. One workaround is not to open databases from Windows Explorer, but always from within Access, i.e. you must start the correct version of Access first.
    Another workaround is to create shortcuts for each database that open it in the correct version of Access.
    A third workaround is to create options "Open with Access 97" and "Open with Access 2000" in the right-click menu for .mdb files. This is done in Windows Explorer, from the File Types tab of the Tools | Folder Options... dialog.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 41 Times in 40 Posts

    Re: Having access 97 & 2000 on one PC (MSAccess)

    I remember seeing mention of a utility that would open a database in the correct version of Access. I'm pretty sure it was on one of the more well-known Access sites, and it was free. But I can't seem to find it. You might try a Google search.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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