Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    user level security Access 2007 (2007)

    I' know that this has been eliminated. If you want to implement it, are there any good tutorials or articles out there about it. A quick Google did not find anything very useful.
    Thanks

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

    Re: user level security Access 2007 (2007)

    The new version of the Jet Engine doesn't support user-level security for the new database format .accdb, but it does for databases in the older .mdb format, and it works the same there as in Access 2003. See Set or change Access 2003 user-level security in Access 2007 - Access - Microsoft Office Online.

    For general info about user-level security, see WendellB's tutorial The Secrets of Security (lots of useful links).

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: user level security Access 2007 (2007)

    What I am wondering is there is a way to implement in the new format, a system that emulates the old way? Has nayone thought about this, or why is it not needed? I would like to have some forms that are visible only to certain users.

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

    Re: user level security Access 2007 (2007)

    Microsoft's philosophy is that if you need user-level security, you should use SQL Server as a backend. But of course, this works only at the data level (tables and views/queries).

Posting Permissions

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