MS-Access and SQLSERVER2000

  • Not that I am aware of. The only thign I could think of is to do a Select on master.dbo.sysprocess and look for program_name like '%Office%' or '%Access%', which there could be others. Then issue a kill in SQL against them. I know how you feel though as Access is bad about the whole round trip thing and can be the cause of many server issues. What I would do is periodically audit sysprocesses and find out what users are doing this then take it up with them directly. If anyoen else knows a way though I would be interested in the information.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply