Results 1 to 4 of 4
  1. #1
    JennR is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    2

    Need Help w/ Access 2010 Web DB Security!

    Hi,



    I have been tasked with building our Sales/PM DB for our company. I am looking for help with user-level security for a Web DB (Access 2010). Our DB needs to be a Web DB since our Sales Reps could be working from any computer.

    When a Sales Rep logs in, they should be able to see only their leads/opportunities/sales that they are associated with in each table (leadsTable, customersTbl, etc). Our Sales Managers, should be able to log in and see all his Sales Rep's data. I would like to stay away from creating hundreds of individual tables/forms for each Sales Rep/SalesManager. Each should be able to see their own records in the overall data sheets/tables.

    I haven't had much experience with Access for this and I really appreciate any and all help!

    Thanks,

    Jenn

  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
    How are you deploying on the web - SharePoint?

    User logs in, use their login info to filter forms and reports by their user ID. Filter criteria will have to be built into each form and report.
    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
    JennR is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    2
    Hi,

    We have a GoDaddy account that lets us upload our Access Database to it. However, I'm really nice at Access and don't even know where to start. I already have my database set up as a Web DB. I don't know where to start with creating a User login and then linking it up to GoDaddy/Web.

    Thanks!

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Sorry, I've never built web db and know nothing about GoDaddy. I do have procedure to get username from network login and use that to grab their UserID from Users table. I can use the UserID to filter records. No idea how this would be implemented in web db.
    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. Replies: 13
    Last Post: 11-18-2013, 02:20 PM
  2. Replies: 8
    Last Post: 06-18-2013, 04:41 PM
  3. Replies: 1
    Last Post: 05-31-2013, 02:50 PM
  4. Replies: 1
    Last Post: 03-20-2013, 07:02 AM
  5. How do i remove access 2010 security
    By sam49 in forum Security
    Replies: 26
    Last Post: 11-15-2010, 10:22 AM

Tags for this Thread

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