Results 1 to 6 of 6
  1. #1
    Xterra14s is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    May 2016
    Posts
    32

    Multiple user interfaces?

    Hello everyone,


    I'm currently building a database for my internship site for a ticket/help desk system. Here's my question, upon research online I haven't been able to find any answers.
    • I want to have multiple users be able to log into this system
    • I want each user to have their own view when they log in
      • ex: when they log in they can view only the tickets they opened since they would be saved based off their username and password

    • When they go to enter a ticket the DB automatically realizes who they are are opens the ticket in their name


    These are just a few things I have in mind at the moment and just want to know if it's possible to build it this way.
    I could do it by having different forms for each user and when they login with the correct username and password it opens the form that's linked to their name but this will take up a lot of space. The more users --> more forms, and I don't want to go this route.

    Thank you

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    These are just a few things I have in mind at the moment and just want to know if it's possible to build it this way.
    perfectly possible
    I could do it by having different forms for each user and when they login with the correct username and password it opens the form that's linked to their name but this will take up a lot of space. The more users --> more forms, and I don't want to go this route.
    you wouldn't - one form, filter the recordsource for different users based on their login

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    In addition to Ajax's comments,

    • I want to have multiple users be able to log into this system
    • I want each user to have their own view when they log in
      • ex: when they log in they can view only the tickets they opened since they would be saved based off their username and password

    To build a multi-user dB, you would want (actually need) to split the dB into a FE (front end) and a BE (back end).

  4. #4
    Xterra14s is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    May 2016
    Posts
    32
    Is it difficult to split it this way? I'm new to multiple users set up this way.

  5. #5
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    it will be harder to maintain and prone to corruption if you do not split

    tables only go in back end and it is located on the network where all users can access it

    forms, reports, queries and code go in the front end and every user has a copy which is linked to the back end

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

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

Similar Threads

  1. Multiple User Design
    By jewll in forum Database Design
    Replies: 2
    Last Post: 10-27-2014, 12:08 AM
  2. Multiple User login
    By Bradonnmorgan in forum Programming
    Replies: 2
    Last Post: 03-11-2013, 10:24 AM
  3. Multiple language interfaces
    By cavancura in forum Database Design
    Replies: 3
    Last Post: 12-08-2011, 01:36 PM
  4. Multiple end user have DB open
    By Desstro in forum Programming
    Replies: 5
    Last Post: 11-27-2010, 10:13 PM
  5. Multiple User Limitations
    By Nosaj08 in forum Access
    Replies: 12
    Last Post: 02-16-2010, 06:11 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