Open MS Access from EA

[Maarten]

In the help documentation on automation one can find that it is possible to call an external application from within EA. I set this up for MS Access an defined the argument $f such that my EAP file was directly opened in MS Access.

Unfortunately this does not seem to work when the name of the EAP file contains a space. Hence my shortcut worked fine for a file with a name like C:\MyPath\MyFile.eap. However when I tried it for a file with a name like C:\MyPath\My File.eap it did not work because MS Access could not find the file C:\MyPath\My.mdb.

Does anyone know if it is possible to avoid this 'trunc' of the file name?

[thomaskilian]

Har har! This MS DOSis! Parameters are passed with string separators (blanks). I made a rather strange hack to get across this one (filling in unusual string delimiters and concatenate between - does not work with filename that have multiple blanks).  

[mikewhit]

Don't suppose using %20 for 'space' helps, does it ?

[Maarten]

Using the %20 solution requires that I know my filename in advance. I thought it was possible to configure a generic solution that would open the active EAP file in MS Access by using the parameter $f. If I know my filename I can simply use it and put it between quotes (according to the EA-help that should also function).

[thomaskilian]

You might look into my Perl/BAT coding on EAUG.