Results 1 to 3 of 3
  1. #1
    Lee87 is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    1

    Security for queries

    Hi all 1st post here,



    Im creating a database at work and struggling with the security. I have a database to store projects for different sites. But I need to make it so the sites can only see there own.

    So say i have 3 sites A,B,C i need it so only A,B,C can see their own, and then a 'management' level that can see all 3.

    Is there a simple way of doing this?

    I thought initially i could have one database with a different login for each site and they would only see what they create. This seems difficult.

    Would it be easier/possible to have 3 seperate databases for each site, that then feed into one database for managers?

    Thanks in advance
    Lee

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    You would have to determine who is using the database by either having them login or grab their identification from the network. Then filter forms and reports appropriately based on who user is. Would need table of users.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    David04845 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2012
    Posts
    16
    If they do not have access to the tables or query you could do this.. (theory)

    set a blank field in the Q and set an expression on it
    exp1: iff([Enter Password]=123456,0,1)
    then below it type under criteria >=1

    when they run the Q it will ask for [Enter Password] then validate it to 123456

    if the password is incorrect it will return a value of 0 and not show a record because the criteria is set to >=1.

    If they type the correct password it will return a value of 1 and show the records as 1=1.

    You would want to mark this row as do not show. and it wont work in a crosstab.

    Note that if the user can view the design of the Q this is utterly useless.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 10-26-2011, 02:09 PM
  2. Mcro security
    By itm in forum Security
    Replies: 2
    Last Post: 09-28-2011, 03:00 PM
  3. Security
    By cap.zadi in forum Security
    Replies: 0
    Last Post: 09-20-2011, 04:24 AM
  4. Security Help
    By Cheshire101 in forum Security
    Replies: 4
    Last Post: 03-30-2011, 02:43 PM
  5. Security..Is there another way?
    By marianne in forum Security
    Replies: 0
    Last Post: 07-19-2009, 07:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums