Results 1 to 7 of 7
  1. #1
    accessnewb is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    New York, NY
    Posts
    116

    Manage attachments

    I have a form in which the fields are enabled or disabled based on user permissions. If a user has only 'Read' permission then all the fields are disabled else the fields are enabled. Now I also have an attachment field in my form. If I disable the attachment field, then the user is unable to view the attachments. I want the users with 'Read' permission to view the attachments but not manipulate it. Like, a user with 'Read' permission must not be able to 'Add' or 'Remove' an attachment, but he must be able to 'Open' the attachment and 'Save' the attachment.

    Is that possible?



    P.S: I have used the default 'attachment' which comes with MS-Access, that is I have added a field with the datatype 'attachment' and made my textbox a bound field in the form.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    have you tried setting the permission on the folder rather than through access? if all your files are in a shared location can you not set their network permissions to read only on that folder/those folders? Then in your access database you wouldn't restrict that field from being viewed, but if they tried to view it and didn't have permisson it wouldn't open.

  3. #3
    accessnewb is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    New York, NY
    Posts
    116
    hmmm, that is gonna be hard as the client has specified that I do everything through access. Right now, I have made someone an admin and give them an option to 'Manage users' in access. This is simple as all the admin has to do is create a user and specify a permission level. The client is not going to like setting permissions on the folder.

    Is it not possible to manage attachment if I give permission in access?

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I don't use the attachment field (I use text and store a path), but have you tried locking rather than disabling the controls? Enabling doesn't allow focus but locking does.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    accessnewb is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    New York, NY
    Posts
    116
    yayyy!! Locking does exactly what I am looking for!!!! Thanks!

  6. #6
    accessnewb is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    New York, NY
    Posts
    116
    Oh hmm, new question. What if there are 3 levels of permission? Read, Read Write and Read Write delete? In that case the "Read" user must be able to view but not add or remove. The "Read Write" user must be able to view and add but not remove and the "Read Write Delete" user must be able to do all 3.

    Is it possible?

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Glad it worked! Sometimes shots in the dark hit the mark.

    Have you considered setting the AllowEdits, AllowAdditions and AllowDeletions properties of the form rather than individual controls. Sounds like they might give you the level of control you need.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. attachments
    By chiefmsb in forum Access
    Replies: 0
    Last Post: 07-08-2011, 03:56 PM
  2. attachments
    By chiefmsb in forum Access
    Replies: 1
    Last Post: 06-28-2011, 04:20 PM
  3. Replies: 6
    Last Post: 06-26-2011, 03:13 PM
  4. splitting tables to manage their size
    By aat in forum Database Design
    Replies: 5
    Last Post: 09-22-2010, 12:47 PM

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