LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Disabling access to MSquery

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting external data from Access 2007 using msquery terry???????? Excel Discussion (Misc queries) 0 June 19th 08 05:16 PM
viewing newly created access queries in excel via msquery CWCPGCFin Excel Discussion (Misc queries) 0 September 29th 06 10:32 AM
Refresh MSQuery w/ Access datasource issue Chris B Excel Discussion (Misc queries) 1 June 29th 06 08:46 PM
PB import with MSQUERY from Access ton Excel cyberjc Excel Programming 0 March 16th 05 10:05 AM
Importing Access record into Excel using MSQUERY question Harry[_7_] Excel Programming 3 February 14th 05 02:36 PM


All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"