launch ms access from query analyzer

[chaoma]

This might be a simple question, but I can't do it.

I would like to launch Microsoft Access 2003 from my query analyzer.

I am using:

exec master..xp_cmdshell '"c:\program files\microsoft office\office11\msaccess.exe"', NO_OUTPUT

But it just hang and time out.

Thank you for any help.

Chaoma

 

[mrdenny]

xp_cmdshell will not launch Access to the screen. It will run it in the background (check task manager it's probably running until you stop the query) of the server.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[chaoma]

You're right, it showed up in task manager, but doesn't do anything.

Anyone know how to launch it?

Thanks.

 

[vongrunt]

Tools -> Customize -> Tools, add menu item for msaccess.exe, OK.

Then click on the bottom of Tools menu. .

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[mrdenny]

You have to launch it from outside of SQL. Running Apps from within T/SQL using the xp_cmdshell will not make them run interactively.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[chaoma]

Thank you Denny. I will have to schedule it using another program.