Hide SQL Query

[Wayne Wengert]

Is there a way to hide (or at least prevent editing) of the Query used to
get data from an SQL Server?

Wayne

 

[Fredrik Wahlgren]

Is there a way to hide (or at least prevent editing) of the Query used to
get data from an SQL Server?

Wayne

Hide from who? The Excel user? The Profiler? Where do you keep your query?

/Fredrik

 

[Wayne Wengert]

Sorry... from the user. The users know just enough to be dangerous
(<smile>).

I built the query from within the spreadsheet. Right now, if you click on a
cell in the data range you get a popup that, among other things, has the
option "Edit". That is not good in our environment.

Wayne

 

[Guest]

If you lock the Extracted Data range and Protect the Wsht, then the Edit
Query in not available on right clicking a cell in the data range.
The downside is that you will need to Unprotect/Refresh data/Reprotect the
sheet.

 

[onedaywhen]

... from the user. The users know just enough to be dangerous
(<smile>).

If you don't want them to change the SQL e.g. retain the same column
order, the same WHERE clause etc then put the query into a stored
procedure and call the proc from MS Query. They could of course still
completely change the call e.g. to another stored proc or write their
own SELECT query.

Jamie.

--

 

[Wayne Wengert]

Thanks for the suggestions. The SP is probably the best route.

Wayne