hidden queries

From: Jeanne (jconroy_at_solutions-center.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 18:26:10 -0400

I am working in Access 97 and wanted to protect a query from being modified.
I right-clicked the query in the database window, chose Properties and
hidden. The query became invisible. The report based on it runs fine, but
I don't know how to unhide the query should I need to edit it. Can someone
help, please?

Relevant Pages

  • Re: Protect Microsoft Query
    ... Consider putting this in the sheet activate event and then ... Another option is to code your own Refresh button and protect the sheet. ... The regular Refresh button, along with the Edit Query button, will be ... Excel Blog - Daily Dose of Excel ...
    (microsoft.public.excel.programming)
  • Re: field changing unexpectedly
    ... Not only will this fix a number of bugs, it will protect you from ... >>statements and the query that is giving you trouble? ...
    (microsoft.public.sqlserver.server)
  • Re: prevet users to view and modify MS query
    ... Maybe you could use a macro to create the query>get the data>delete the query name. ... Protect the macros. ... to refresh data (or enable automatic data refresh once file.xls is open. ...
    (microsoft.public.excel.programming)
  • Re: Protect a Worksheet
    ... The query will refresh as you say upon opening. ... Set the query to load manually, then in the workbook open event unprotect sheet, run query and then re-protect the sheet ... Leave query to refresh but before saving/closingthe workbook unprotect the sheet, then after the query has run re-protect the sheet ... I have put the protect in the begining of the worksheet that I want ...
    (microsoft.public.excel.programming)
  • Query Into Protected Sheet - Excel 2000 on WinXP Home (SR2)
    ... I am using a Saved Query to ... the workbook display a re-formatted ... version of the data from the sheet being ... protect the query sheet, a message ...
    (microsoft.public.excel.programming)