Results 1 to 4 of 4
  1. #1
    mussy is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    10

    Reports Security Protection

    Hi all,



    How and what vba code do i need please so that I can allow some users the right to edit and make changes in the database and reports and most users "Read Only" only? Thanks in advance

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    You can't really do that other than with possibly network security. If someone knows their way around access you can't secure it from being changed other than at the network level that I know of (and seems to be foolproof)

  3. #3
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    It depends on what exactly is your terminology:

    "edit and make changes"

    a. if you mean to the data; then you must set up yourself a log in method so that the database knows who is the user - - and then integrate this into the forms/reports so they only display the appropriate data. It can get complicated but is a fairly common requirement in the real world.

    b. if you mean design view of the forms/reports themselves - - then you need to control the type of front end that is distributed; as the compiled mde / accde will prevent design view and is given to those that need to be stopped from design view.

    Hope this helps

  4. #4
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    in point a. above: locking and unlocking fields ....I meant to include that aspect as well.....

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

Similar Threads

  1. Replies: 1
    Last Post: 05-31-2013, 02:50 PM
  2. Replies: 7
    Last Post: 03-12-2012, 09:18 AM
  3. Password protection
    By peshonzi in forum Forms
    Replies: 1
    Last Post: 07-07-2011, 04:09 AM
  4. Split Database / Added Security - No Reports now
    By rodeoboy in forum Security
    Replies: 16
    Last Post: 02-11-2011, 10:57 AM
  5. help please. i need basic access privacy/protection ideas
    By helpporfavorplz in forum Security
    Replies: 1
    Last Post: 02-20-2010, 05:32 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