Open a query

Results 1 to 2 of 2

Thread: Open a query

  1. #1
    Join Date
    Dec 1969

    Default Open a query

    Hi<BR><BR>I have a query which I need to merge with MS Word (Mail Merge).<BR>Is there a way to open this query, but make it invisible to user. For now I put that query in the menu, but when I press it I get open query which user can change.<BR><BR><BR>Is there a way to do this?<BR><BR><BR>Thank you<BR>

  2. #2
    Join Date
    Dec 1969

    Default If you are using MS Access...

    you can hide queries and tables and bascially anything you like. This won&#039;t stop a more advance user to unhide the query and edit it, but it&#039;s a start.<BR><BR>If you want more protection, you can even go as far as using access control to stop your users from unhiding and editing the query. It&#039;s worth getting a book on access control, because it&#039;s quite a complex subject.<BR><BR>If you just want to hide a query, go to the database window, right-click the query, select "Properties" from the pop-up menu and tick the "Hidden" box. Then simply "Apply" or "OK" the dialog and you&#039;re done.<BR><BR>Oliver.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts