I have 2 versions of Access installed on my system. I have a vbs file that opens the mdb file via the vbscript file....this worked fine as long as I only had one version of MS Access installed, now that I have A97 and AK3 I need the vbscript file to use the A97 EXE to open the mdb file, since I want to continue to use Access 97 for now.
When I only had Access 97 installed, the script looked like this and worked:
WshShell.Run ("MSACCESS C:\Testing\current.mdb")
With Access 2003 installed, I would like to make the mdb file open with the Access 97 EXE, so I did this, but it doesn't work:
WshShell.Run ("C:\Program Files\Microsoft Access 97\Office\MSACCESS.EXE" "C:\Testing\current.mdb")
Can anyone help with this.
Thanks
BJS
When I only had Access 97 installed, the script looked like this and worked:
WshShell.Run ("MSACCESS C:\Testing\current.mdb")
With Access 2003 installed, I would like to make the mdb file open with the Access 97 EXE, so I did this, but it doesn't work:
WshShell.Run ("C:\Program Files\Microsoft Access 97\Office\MSACCESS.EXE" "C:\Testing\current.mdb")
Can anyone help with this.
Thanks
BJS