How can you kill an Access process?

[RichS]

In MS SQL Server 6.5 how do you kill a process where a user is running a select statement from MS Access. When I try to kill it by going to "Current Activity", selecting the process then selecting "Kill Process" it does not work.

Thanks.
Rich

 

[tlbroadbent]

Usually, the user will have to terminate the process on the client and exit Access. Sometimes the user must restart their PC.

You can also stop and restart SQL Server but that is not often convenient. Occasionally, SQL Server will not stop and the Server must be rebooted.

BTW: We also seem to have this problem in SQL 7 from time to time. Terry

;-) I never worry about the future. It comes soon enough. -Albert Einstein

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm

 

[RichS]

OK. I was hoping that there was some system command (like the "kill -9" command in unix) I could use when this happens. One of our users runs reports from an Access connection and every now and then he will lock up the other 50 or so users.

Thanks.
Rich

 

[tlbroadbent]

T-SQL has a kill command. Enterprise Manager uses the kill command when you select "kill process." You can try kill in the query analyzer. Execute "kill spid" wher spid is the "system process ID" of the offending run. Terry

;-) I never worry about the future. It comes soon enough. -Albert Einstein

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm

 

[RichS]

Thanks Terry,
I will give it a spin and see what happens.

Rich