Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941

    Unanswered: 2 Versions of Access on same machine

    I have an AccessXP app that I distribute throughout my office. That APP is launched via a VBScript that checks the currently installed version on the local pc against the version on the network. If the versions are different, then
    the script copies the network version to the local pc.

    Recently, on one of the pc's, someone else created a shortcut to open an
    Access97 database (both versions of Access are installed). Now whenever the user launches the VBScript to open my app, it automatically launches Access97. Is there a way to force it to open AccessXP instead?

    Thanks
    Inspiration Through Fermentation

  2. #2
    Join Date
    Jun 2002
    Location
    Mpls/St.Paul area
    Posts
    303
    "That APP is launched via a VBScript"

    Using a shortcut, you can specify the location of access you want to open and then the database you want to open.

    For example the target can read...
    "C:\Program Files\Microsoft OfficeXP\Office10\MSACCESS.EXE" "C:\Myfolder\MyXPdatabase.mdb"

    or "C:\Program Files\Microsoft Office97\Office\msaccess.exe" "C:\Myfolder\My97database.mdb"

    If you can open the app with a VBScript, I would guess you can also send parameters, such as the instance (path) of Access.exe to open.
    John
    This is the day the Lord has made, I will rejoice and be glad in it.

Posting Permissions

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