Results 1 to 4 of 4

Thread: User Permissions

  1. #1
    ccordner is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2011
    Posts
    65

    User Permissions

    Hi

    I have (I think) a complicated question.

    I have a database, split into a front and back end. It contains a great deal of information about employees.

    I want each employee to be able to record in it their availability for overtime, which would need to be done through Excel (very few of our staff have Access). But in order for Excel to be able to do this, they must have read/write access to the database itself.

    However, this would mean that an enterprising individual could easily get access to the whole database, which I don't want.

    Is there any way of allowing Excel, or Access (I could build a "restricted" front-end) to access just part of a database?

    Hope this makes sense.

    Chris.

  2. #2
    RuralGuy's Avatar
    RuralGuy is online now Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    10,757
    Have you thought of allowing them access to a minimum separate BackEnd that you could then access from your live system?
    (RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 Pro - acXP, ac07, ac10, ac13
    If your issue is resolved...go ahead and use the Thread Tools at the top of the thread and mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    ccordner is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2011
    Posts
    65
    That's clever! No, I hadn't!

    So I split the back end down into two bits: confidential and non-confidential, then set up the non-confidential stuff as a linked table in the confidential database?

  4. #4
    RuralGuy's Avatar
    RuralGuy is online now Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    10,757
    That would be one way, yes. Only your FrontEnd need know about the two BackEnds.
    (RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 Pro - acXP, ac07, ac10, ac13
    If your issue is resolved...go ahead and use the Thread Tools at the top of the thread and mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. User permissions - access 2010
    By Outlook in forum Security
    Replies: 3
    Last Post: 12-03-2012, 06:19 AM
  2. MDB Permissions
    By esbrega in forum Security
    Replies: 0
    Last Post: 03-08-2012, 01:46 PM
  3. Macro for user permissions
    By Loisw in forum Programming
    Replies: 1
    Last Post: 10-28-2010, 06:47 AM
  4. Permissions
    By emccalment in forum Forms
    Replies: 12
    Last Post: 02-17-2010, 02:11 PM
  5. User and Group Permissions
    By sdondeti in forum Security
    Replies: 1
    Last Post: 02-01-2010, 03:47 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
  •  
Tech Forums: Microsoft Office Forums