Does anyone else need quotes to make Access run?

[DavidAtCaspian]

My first attempt at running MS Access has failed

1) This line:

Run program> C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE C:\Tracking\NewTrack.mdb /x sched (most of which I got copying and pasting)

gives an error message "Error executing ...... (2)"

2) If I remove the macro and try
Run program> C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE C:\Tracking\NewTrack.mdb (ALL of which is copy/paste)

I get the same error.

3) If I remove the path to the mdb and just open access - same error.
4) If I do
Let>filename =C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE

run program>filename

then access starts up, but as soon as I add the mdb, it fails with
"Error Executing" again

If I just do
run program> msaccess.exe, it fails again

After a load of faffing about (A UK expression of exasperation), I finally got it to work by enclosing the actual access command line (but nothing else) in quote marks (").
Now, nowhere in my searches have I seen anyone else having to use quote marks to run a program.
Indeed several examples of ACCESS in these board do not have quote marks.
Am I doing something wrong? Or has my machine been visited by aliens?


I am running the eval version of 8.0.1.


And finally the line that does work is:

Run program>"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" c:\tracking\newtrack.mdb /x sched


Not bad for nearly two hours work and internet investigation??

Any views ??

[JRL]

Assuming you've copied and pasted your failing code. the problem is the space after "Run program> " and the space after "filename= ".

See THIS thread

Hope this helps,
Dick

[DavidAtCaspian]

Great. Much appreciated.
Thanks