Run application

[Karen]

I am trying to run Enterprise Manager from a command button on an access form
- the program will run but I want it to then open a console file that is in a
different location.

The command I have at the moment is:-

C:\WINDOWS\system32\mmc.exe /s "C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC

any ideas gratefully received.

Karen

 

[kingston via AccessMonster.com]

Is the file associated to EM on the computer in question? If so, try opening
the file directly as a hyperlink from your command button:

Application.FollowHyperlink "C:\Filename"

 

[Karen]

Hi, thanks for the response.

I have already made sure that the file is associated with EM but it didn't
work.

I am trying to open the file SQL Server Enterprise Manager.msc (console) but
it won't recognise that the file wants to be associated with Enterprise
Manager (program) - access reports invalid procedure.

Can anyone help please?

Thanks