Results 1 to 5 of 5
  1. #1
    Tim823 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2010
    Posts
    1

    password protected for me, but not everyone else


    Hello.
    I am the administrator for an Access database (Access 2007), which is shared via a network. I need to limit access to read only for several staff members. I have created users, groups and assigned permissions to the users. I have also used the security wizard to create an enhanced security database. Everything works fine on my PC, but when colleagues open the database from their systems, none of my enhanced security features show up. I have no idea why. Does anyone know why security enhancements (like the login box) would show up on my PC, and not the rest of the staff’s? Thank you for any help you can provide.

  2. #2
    Datagopherdan is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Dec 2008
    Posts
    220
    First off Access 2007 does not have user level security as the previous versions did, so are you sure that you're running Access 2007? From the sounds of it, it sounds like you're opening the database through a shortcut that is pointed to a workgroup where you would be required to enter credentials. The users are probably just accessing the database directly without using a shortcut.

  3. #3
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155
    Have you added the work group to all the users computers?

  4. #4
    apr pillai's Avatar
    apr pillai is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    209
    If you using an Access2003 database in Access2007 then you can maintain User-level security in Access2007.

    I have published a Blog Post on this subject last week. I have given few details in there, take a look at it: Running Workgroup Admin in Access2007.

  5. #5
    Jacy757 is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Sep 2011
    Posts
    3

    Hi,

    It seems that you have not added work groups to all users computers that is why it is creating security level problem.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Virtual Password-Protected Connection
    By marianne in forum Sample Databases
    Replies: 6
    Last Post: 02-18-2011, 10:41 AM
  2. VB Password
    By SAHeat6902 in forum Security
    Replies: 1
    Last Post: 09-30-2009, 03:13 AM
  3. Replies: 0
    Last Post: 10-22-2007, 02:15 AM
  4. ***PASSWORD HELP***
    By hawkinsgal in forum Access
    Replies: 2
    Last Post: 11-23-2006, 09:10 AM
  5. Change from old password to new password
    By richy in forum Security
    Replies: 0
    Last Post: 11-17-2005, 05:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums