Help (Shell Command)

[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

 

[Wayne Morgan]

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.

 

[Wayne Morgan]

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

 

[arni]

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"


.