Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Naive security question (2002)

    If a database is split, does security and permissions need to be set/ assigned for both the linked tables in one database and the 'live' tables in the other database? Should the database be split before or after setting security?
    I also assume that if a form's data is obtained from two tables then the user would need permission to view data from both tables..
    Sorry if these questions seem naive. Thanks, Andy.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Naive security question (2002)

    Here is a link to Access Security FAQ
    Linked tables are treated in question 12 to 19.
    As for your second question, yes, each table need the permissions. You can also not give any permission at the table level and use queries with Run with Owner permission. See question 10.
    Francois

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

    Re: Naive security question (2002)

    You need to secure both frontend and backend. You can apply security before or after splitting.

    If a form or report is based on multiple tables, the user must have permission to view the data in all tables involved.

    The Microsoft Access Security FAQ (downloadable Word doc) contains a lot of info that relates to your questions.

Posting Permissions

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