Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have several data queries in a workbook that extract certain details from a
SQL database. A variety of functions are then performed on the results and a graphical view of the results is diplayed for the user. The intent behind the workbook is to act as a viewer for our ticketing system that allows Incident Management to make informed decisions about which tickets need to be worked when to meet a variety of Service Level Agreements. What I now need to do is to lock the queries so that the SQL code cannot be viewed. I think if I remove the all entries for Import External Data from the Data menu and also edit the Query commandbar, I should be able to prevent viewing of the queries. What I don't know are the command codes associated with these menu options. Also, will removing access to the query menu options prevent someone from viewing the query definitions or do I need to lock these out another way? -- Thanks, R Woltner |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting external data from Access 2007 using msquery | Excel Discussion (Misc queries) | |||
viewing newly created access queries in excel via msquery | Excel Discussion (Misc queries) | |||
Refresh MSQuery w/ Access datasource issue | Excel Discussion (Misc queries) | |||
PB import with MSQUERY from Access ton Excel | Excel Programming | |||
Importing Access record into Excel using MSQUERY question | Excel Programming |