04-28-04, 09:42 #1Village Idiot
- Join Date
- Jul 2003
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?
ThanksInspiration Through Fermentation
04-28-04, 10:59 #2Registered User
- Join Date
- Jun 2002
- Mpls/St.Paul area
"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.