March 18, 2002 at 11:09 pm
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 ?
March 19, 2002 at 4:53 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy