Compact & Repair another database using shell

[Adam Thwaites]

If I type this in the run box it works fine:

"C:\Program Files\Microsoft Office\Office11\msaccess.exe" "C:\Database\PAF
Address A-C.mdb" /compact

How ever If I try and run it in VBA using the shell command it doesn't do
anything:

Shell "cmd.exe 'C:\Program Files\Microsoft Office\Office11\msaccess.exe'
'C:\Database\PAF Address A-C.mdb' /compact"

Is there something wrong with my code?

 

[Stefan Hoffmann]

hi Adam,

How ever If I try and run it in VBA using the shell command it doesn't do
anything:

Shell "cmd.exe 'C:\Program Files\Microsoft Office\Office11\msaccess.exe'
'C:\Database\PAF Address A-C.mdb' /compact"

Why are you trying to run it in a separate cmd process?

Is there something wrong with my code?

Removing the cmd.exe shoudl be sufficent.


mfG
--> stefan <--

 

[Douglas J. Steele]

hi Adam,



Why are you trying to run it in a separate cmd process?



Removing the cmd.exe shoudl be sufficent.

Will the single quotes work with Shell? He might need to use

Shell """C:\Program Files\Microsoft Office\Office11\msaccess.exe"" " & _
"""C:\Database\PAF Address A-C.mdb"" /compact"

 

[Adam Thwaites]

Sorted, thanks!

Shell """" & "C:\Program Files\Microsoft Office\Office11\msaccess.exe" &
"""" & " " & """" & "C:\Database\PAF Address R-Z.mdb" & """" & " /compact"