Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2010
    Posts
    6

    Unanswered: User Level Security Help Needed

    I was messing around with the user level security and now i cant change the current user. when i open the DB i don't get a login screen, it just opens up with an account that has limited permission. Please help

  2. #2
    Join Date
    May 2010
    Posts
    601
    Quote Originally Posted by kimmykim View Post
    I was messing around with the user level security and now i cant change the current user. when i open the DB i don't get a login screen, it just opens up with an account that has limited permission. Please help
    Welcome to dbForums.

    Learning to use the build in Ussr Level Security (ULS) in Jet4 and earlier (Access 2003 and earlier) can be overwhelming. That has lead to it not being used by very many. That may be part of the reason why it was dropped in the new Access 2007 ACE database.

    I would recommend reading this:

    Access User-Level Security

    How I use Microsoft Access User-Level Security by Jack MacDonald

    I would strongly recommend that you practice on a copy of your database as you are learning.
    Last edited by HiTechCoach; 07-10-10 at 17:02.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    Jul 2010
    Posts
    6
    thanks for the advice. Luckily i have a copy of the db on another computer

  4. #4
    Join Date
    May 2010
    Posts
    601
    Quote Originally Posted by kimmykim View Post
    thanks for the advice. Luckily i have a copy of the db on another computer
    You're welcome.

    That is good!

    I strongly recommend that you make daily backups. Will developing on the front end, make lots of back ups as you go.


    IMPORTANT: Don't forget to back up your work group file (.mdw) with every back up!

    If you lose the work group file you should be locked out of your database, if the security was properly applied.

    Also see:
    Splitting your Access database into application and data
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

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