Results 1 to 4 of 4
  1. #1
    videoclocknet is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    10

    Deny insert/delete/update to a user for the whole Access database

    Hi guys,


    In our small company, we've got an Access Database on our Windows Server 2012, which is shared through the M: unit of the network. Each employee has got its own .mdb file in its own PC with its owns forms. All these forms are "connected to" the Access Database that is located in the M: unit of the server.




    I'm trying to deny the insert/delete/update privileges to some employees, so they can only make "select" queries.


    I know that I can Allow Deletions property of the form to False (No), but there are about 150 different forms.


    I know that I can also remove the Delete Data permission for the table, to prevent users accidentally deleting records. But there are about 100 different tables in the database.


    So is it any way to deny inserts/deletes/updates to a user for the whole Access database?


    Regards


  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    AFAIK, individual user permission/security went out with Access 2003. If this is critical might have to upgrade to SQLServer or MySQL.

    Other than having a user login process and then setting form properties with VBA as well as disabling ribbon and menus and/or publishing db as an executable - I don't see any way to do what you want.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    One thought, completely untested, is to only give those users read permissions on the folder the back end is stored in. That may give them read-only access, since they'll be unable to write to the lock file.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    videoclocknet is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    10

    [SOLVED] Deny insert/delete/update to a user for the whole Access database

    Ey guys, thanks for your support.

    Finally, I'm changing the "Allow Deletions" and similar properties of the forms to "No". It's a big work if I do it for 150 forms, but a sure job.

    We're thinking to migrate to SQL Server, so definitely it would be more manageable.

    Kind Regards

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

Similar Threads

  1. Update, delete and insert queries between two tables
    By ideasfactory in forum Queries
    Replies: 5
    Last Post: 05-19-2015, 08:25 AM
  2. Update, Delete and Insert Help
    By cshannon in forum Access
    Replies: 1
    Last Post: 02-10-2014, 10:59 PM
  3. user access to delete
    By 54.69.6d.20 in forum Programming
    Replies: 3
    Last Post: 07-31-2012, 09:44 AM
  4. Replies: 12
    Last Post: 10-20-2011, 08:22 AM
  5. update vs. delete / insert
    By markjkubicki in forum Programming
    Replies: 1
    Last Post: 09-23-2010, 07:44 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