Using Access projects I am connecting to a SQL database usine connections. The front is using bound forms, this required users to have read and right access to tables and/or views through AD security groups. While I can sufficently control user interaction. However, I need to be able to block users that attempt to connect through Excel/ODBC etc, who can now do considerable damage.
Can I further restrict SQL connections to ensure that the database will only allow connections from the Access Front-end, the web application and Reporting services.
View Complete Post