View Single Post
  #2   Report Post  
 
Posts: n/a
Default



Cheryl R. wrote:
Our SQL tables are not secure & we've found that Excel 2003 allows users to
import data from the server without having to go through the ODBC DSN
process. I tried deleting the drivers, but Excel External data function
still works. Any ideas on how to disable Excel's access to our db?


If the user has access to the server, why not let them use Excel for
data? Turn it around, if you don't want a user to access the data then
revoke their permissions on the server.