Results 1 to 2 of 2
  1. #1
    Nixx1401 is offline Competent Performer
    Windows Vista Access 2003
    Join Date
    Feb 2010
    Location
    Barbados
    Posts
    115

    Permissions for sharing a database

    I have a split database which I would like to share between two departments. I want one of the departments to have full access permissions to the database and create a form for the other department to view and select a check box. I dont want the department with the view and select check box permissions to make any other changes to the database and the ability for them to only view the other reports.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You will have to set permissions for what users can do based on their ID and related department info. This will require VBA code to enable/disable controls (buttons, textboxes) or set them as visible/not visible.

    Do a search of this forum on keywords: password username. This topic has a lot of discussion. Here is one https://www.accessforums.net/access/...ord-19004.html
    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.

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

Similar Threads

  1. Permissions
    By helpaccess in forum Access
    Replies: 2
    Last Post: 04-22-2011, 03:33 PM
  2. Sharing the database file
    By mme in forum Access
    Replies: 4
    Last Post: 09-10-2010, 08:45 PM
  3. Permissions Issue
    By softspoken in forum Access
    Replies: 2
    Last Post: 04-30-2010, 09:36 AM
  4. Permissions
    By emccalment in forum Forms
    Replies: 12
    Last Post: 02-17-2010, 04:11 PM
  5. sharing database over several users issue
    By marianne in forum Access
    Replies: 8
    Last Post: 06-02-2009, 07:20 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