Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    User Security FE/BE (Access 2002)

    When you secure a BE/FE database, when you put the permissions on the BE tables do these permissions then filter thru to the FE tables.
    I understand the permissions that you set on the FE then protect the queries, forms, reports, etc, all except the tables.

    Do you need to set the permissions on the FE linked tables?

    So in essence, do you:
    1. Set permissions for the tables in the BE database
    2. Set permissions for everything in the FE except the tables.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: User Security FE/BE (Access 2002)

    You are correct - there are some issues associated with users needing to relink to tables that may necessitate some special considerations in unusual circumstances - see page 13 of Jack MacDonald's excellent tutorial on security.
    Wendell

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: User Security FE/BE (Access 2002)

    Thanks for that, It certainly is an excellent tutorial. There is a lot to it, isn't there.

Posting Permissions

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