Using an ODBC connection with Excel 1

[comcon]

We are using MSQuery in Excel to connect to our SQL server via an ODBC link. It works very well, in fact, too well.

Many in our organization are wanting to do this, but at this
point there is no way to limit their access to tables.

How can we let them use MSQuery, but only on the tables that
we allow them?

Thank you for your thoughts.

 

[Hasit]

As far as I am aware you can't. I had something similar for a company I was consulting for. The solution for us to make a copy of the database, link it to the original (for updates etc) and zero all the tables that we did not want anyone to use.

Pain in the a** but it worked, because once in Excel they could manipulate the data as they wished.

Others in this forum might have other ideas (or a solution!)

 

[comcon]

Thanks,
I had not thought of that, but it certainly would be a way.
Like you say it is a little unwieldly, but certainly better
than having someone see data that they should not.