jtalbott
asked on
VB code to launch and run an ACCESS DB
I'm trying to get a Macro to run to open an Access 2007 DB which is located on a shared drive S.
I get this error message " There is no script engine for this file extension".mde"
This is the code:
[PCOMM SCRIPT HEADER]
LANGUAGE=VBSCRIPT
DESCRIPTION=
[PCOMM SCRIPT SOURCE]
OPTION EXPLICIT
autECLSession.SetConnectio
REM This line calls the macro subroutine
subSub1_
sub subSub1_()
Dim wshShell
Set wshShell = CreateObject("WScript.Shel
wshShell.Run "WScript.exe S:AcsData\Disco.mde", 1, False
end sub
I get this error message " There is no script engine for this file extension".mde"
This is the code:
[PCOMM SCRIPT HEADER]
LANGUAGE=VBSCRIPT
DESCRIPTION=
[PCOMM SCRIPT SOURCE]
OPTION EXPLICIT
autECLSession.SetConnectio
REM This line calls the macro subroutine
subSub1_
sub subSub1_()
Dim wshShell
Set wshShell = CreateObject("WScript.Shel
wshShell.Run "WScript.exe S:AcsData\Disco.mde", 1, False
end sub
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Opps...
Try this:
wshShell.Run "C:\<<path to EXE>>\MSAcess.exe S:AcsData\Disco.mde", 1, False
Try this:
wshShell.Run "C:\<<path to EXE>>\MSAcess.exe S:AcsData\Disco.mde", 1, False
Programming
Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.
55K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
wshShell.Run "C:\<<path to EXE>>\MSAcess.exe WScript.exe S:AcsData\Disco.mde", 1, False