Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2008
    Location
    Ireland
    Posts
    12

    Unanswered: Forcing Access to open in a specific version

    There has been an update in one of the Microsoft Access databases I use in work. It was originally developed in Microsoft Access 1997 and the newer version is in Microsoft Access 2000. I have set to default to open all databases by default in Microsoft Access 1997 to avoid conversion issues as there are alot of small specialized databases still used in Microsoft Access 1997.

    Mainly there is one Microsoft Access 2000 database to be used by 3 members of a group. I am going to install both versions of Microsoft Access on their computers and just show them how to open the specific database in Microsoft Access 2000 to reduce complexity and the risks that come with conversion.

    So mainly I am wondering is there anyway to get this new version of the Microsoft Access to force it to open in Microsoft 2000?

    Also on an aside, can an MDE made in 2000 be viewed by computers with Microsoft Access? Or would it be feasible to install a Microsoft viewer to their computer so they could just look at it?

  2. #2
    Join Date
    Sep 2007
    Location
    Global Village
    Posts
    185
    Download and Install Access Run Time Application 2007 instead of installing full version of access, it is free and It just run the app for user.
    I don't know if access run time 2003 is available or not but both of them do the same for you.
    you can find it in following link:
    http://www.microsoft.com/downloads/d...displaylang=en
    <<Never Walk on the Traveled Path, Because it only Leads you to where the Others have been.>>
    Graham Bell

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    is there anyway to get this new version of the Microsoft Access to force it to open in Microsoft 2000?
    Yes.

    Use a Windows shortcut that is set to "PATH TO THE EXECUTABLE FILE FOR THE RIGHT VERSION OF ACCESS" "FULL PATH TO THE DATABASE"

    For example:

    "C:\Program Files\Microsoft Office 2000\Office 10\MSACCESS.EXE" "F:\Databases\ApplicationX\DatabaseName.mdb"
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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