Results 1 to 3 of 3
  1. #1
    RichardPowell is offline Novice
    Windows XP Access 2002
    Join Date
    Oct 2012
    Posts
    1

    Basic Access Security


    Hello,

    This might seem like a basic query, but I am trying to add some security on a individual Access front end that links to a SQL back-end. At the moment, it is accessible via a single password on the file, but we would like to add a 'read-only' account. I have set up user permissions on the front end that has a separate admin under the owner's name, and a 'user' account which has access to the file, but cannot change any data.

    The front end lies in a shared area, and it works fine from the account it has been setup on. However, if I logon to a different user on a different PC and open the file from the shared area, the security has disappeared (despite the fact that the mdw file is in exactly the same shared folder). How do we get the security that was setup to propagate to all users? Am I missing something really obvious?

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    My suggestion is that you create a second front end for the 'view only' people. When it comes right down to it, anyone that goes poking around in access can find the tables and modify them if they want to unless you are connected to a SQL table where the PK is not defined. Then you can not make any changes to the table whatsoever.

    As a test I would create 2 databases that are linked to the same SQL table at your facility.

    In the first database, link the table and define the primary key when it asks you to.

    In the second database, link the table and decline to define the primary key.

    Now try to edit both sets.

    You should find you can not modify the second database.

    This is really the only foolproof method I have been able to find to avoid letting certain people have access to your records.

    It sounds like you're trying to set this up with workgroups which I have not had much experience with but I know that it has holes in it.

  3. #3
    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 need any help on setting up Microsoft Access Security, visit this link: Microsoft Access Security

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

Similar Threads

  1. Replies: 2
    Last Post: 01-06-2012, 08:15 AM
  2. how to use visual basic in access
    By learning_graccess in forum Access
    Replies: 3
    Last Post: 12-05-2011, 03:23 PM
  3. Basic Access Help
    By alex2300 in forum Access
    Replies: 2
    Last Post: 06-07-2011, 09:42 AM
  4. Basic security question
    By Tari in forum Security
    Replies: 1
    Last Post: 03-20-2011, 05:02 PM
  5. Basic access issues
    By c2bme in forum Access
    Replies: 1
    Last Post: 03-22-2010, 09:03 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