• quote:

    Does anyone know of a way to prevent people who have query privledges from Accessing SQL Server with MS Access? Has anyone tried Application Roles for this?

    Assume for sake of argument that the reasons for giving them direct query access are valid. MS Access can unfortunately become a powerful tool in dangerously unskilled hands.

    The thread does not explain why it might be important to prevent using Access. My organization allows the use of Access for querying the SQL Server 2000 database. Is there a reason this is not a good idea if the user accounts allow read only?

    Edited by - asippert on 07/07/2003 04:26:27 AM