Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    User-Level Security and Split Databases (2003 (11.5614.5703))

    I'm setting up User-Level Security on a front-end / back-end database. The back-end will be on a server. I want to make sure the users have needed access to the linked tables (via queries, forms, and reports which in turn reference the link tables), but I don't want them to be able to open up the back-end table independent of the front end and monkey directly with the tables. I haven't done this since the Access 97 days; back then (if memory serves), the only (?) way to do this effectively was to set up front end queries that referenced the linked tables and then use the Run Permissions property of the query set to Owner's. Is this still the way to go, or is there a better way in Access 2003?

    Thanks.

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

    Re: User-Level Security and Split Databases (2003 (11.5614.5703))

    According this article, Types of permissions (MDB), it sounds that not much has changed. Read the last paragraph.
    Francois

  3. #3
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User-Level Security and Split Databases (2003 (11.5614.5703))

    Thanks, Francois. Their description is about how I remembered it. It did remind me, though, that I need to remove all the users' permissions from the back-end tables.

Posting Permissions

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