Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Protecting a Query (Access2003)

    I wondered if there was any way of password protecting an (update) query, for example. Since you wouldn't want anyone running the query without authorization, how can we protect it? Thanks in advance.
    Bob W.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Protecting a Query (Access2003)

    Although there are some things you can do to make it more difficult for users to run queries, the only really effective method is user-level security. You can create different kinds of users with different permissions. See The Secrets of Security on WendellB's website; it contains an introduction and many usuful links.

Posting Permissions

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