Help (Shell Command)

  • Thread starter Thread starter arni
  • Start date Start date
A

arni

Need help on how to execute an ms access mde with spaces
in the file name (like below) using shell command. It
gives me an error of command line contains an option MS
access does not recognize. Please advise how to solve
this or other commands I could used?

Filename: "ECO ECN Tracking DB.mde"
Directory Path:\\DOCCON2\MainW\Tracking\

Code: intProg = Shell(.item d="C:\Program Files\Microsoft
Office\Office\MSACCESS.EXE \\DOCCON2\MainW\Tracking\ECO
ECN Tracking DB", vbNormalFocus)

many thanks
 
intProg = Shell("C:\Program Files\Microsoft Office\Office\MSACCESS.EXE
""\\DOCCON2\MainW\Tracking\ECO ECN Tracking DB""", vbNormalFocus)

I tried the above syntax and it appears to work.
 
I just noticed that you also didn't have the mde extension on the file. You
will need to add it to the end of the file name.

ECO ECN Tracking DB.mde
 
thanks wayne, it's working now
:]
-----Original Message-----
I just noticed that you also didn't have the mde extension on the file. You
will need to add it to the end of the file name.

ECO ECN Tracking DB.mde

--
Wayne Morgan
Microsoft Access MVP


"Wayne Morgan"


.
Click to expand...
 
Back
Top