MS-Access and SQLSERVER2000

  • We have a Datawarehouse build on SQLSERVER2000 and BusinessObjects as the reporting & analyses tool. The connection from the client-PC's to the database is through ODBC. We try to avoid that our users are connecting to the database with Microsoft Access (which is installed by default on all the PC's). Does somebody knows a way to instruct SQLSERVER not to allow MS-Access connections/clients ?

  • 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 2 posts - 1 through 2 (of 2 total)

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