How to split a Microsoft Access Database and create multiple users.

แชร์
ฝัง
  • เผยแพร่เมื่อ 13 มิ.ย. 2020
  • How to split a Microsoft Access Database and create multiple users. This video explains how to split a database into a back end and multiple front ends. The tutor explains that the back end is sperated from the users and that the users can only edit their own Forms and Reports but not the back end Table or Queries.
    Most popular video at the moment: adding photos to an Access form. • Adding photos in an Mi...
    Play list for this video: • Access New
    #itseasytraining
    #microsoftaccess
    accesscourses
    Training at www.itseasy.co.uk/
    Online courses at www.itseasytraining.co.uk/
  • วิทยาศาสตร์และเทคโนโลยี

ความคิดเห็น • 20

  • @ITsEasyTraining1st
    @ITsEasyTraining1st  4 ปีที่แล้ว +2

    How to split a database and have multiple users. Checkout courses at www.itseasy.co.uk

  • @eeshanprabhu1609
    @eeshanprabhu1609 5 หลายเดือนก่อน +1

    most helpful video ever

  • @TimRoseOfficial
    @TimRoseOfficial 4 ปีที่แล้ว +1

    *_Very nice vid my friend! Really enjoyed, thanks for sharing! Keep up the great work! :D_*

  • @chapidi99
    @chapidi99 ปีที่แล้ว +1

    Excellent!!

  • @balrajvirdee1087
    @balrajvirdee1087 3 ปีที่แล้ว +1

    Thank you great tip 👍🏽

  • @moodkn
    @moodkn 2 ปีที่แล้ว +1

    Lot of Thanks Sir!.....

  • @pramodghorpade9804
    @pramodghorpade9804 2 ปีที่แล้ว +1

    Very nice ! I am facing one issue with multiple user( only 2) FE database. When my team mate adds some entries in his FE it takes so much time to reflect in my database. Can you please guide how to resolve this !?

    • @ITsEasyTraining1st
      @ITsEasyTraining1st  2 ปีที่แล้ว +1

      It sounds like a network issue. Are both files open at the same time? Check where the database is stored.

    • @pramodghorpade9804
      @pramodghorpade9804 2 ปีที่แล้ว

      @@ITsEasyTraining1st thank you for your response. The backend database is stored on shared drive.and FE database is stored on individual local machine. Me and my teammate we both use it same time. It takes almost 50 min to reflect . As our works are dependent i need to wait till his data gets reflected .It was working fine some day ago.

  • @cgonz81
    @cgonz81 2 ปีที่แล้ว +1

    how can you open multiple front ends one once? We can only open one front end at a time.

    • @ITsEasyTraining1st
      @ITsEasyTraining1st  2 ปีที่แล้ว +1

      Yes, you could have two people workin g on two separate front ends at the same time. The issue would occur if they wanted to edit the same record at the same time, it would be first in first served the second person would have a read only copy

  • @nikolaradovic1726
    @nikolaradovic1726 ปีที่แล้ว +1

    Hi guys ,i have problem with acess database ,he is created a few year ago (2) and multiple user can use them on sharefolder ,but now when 2 user on same time want to acess give message dont have exlusive right to acess .If any know what is answer please reply ,thanks 😊

    • @ITsEasyTraining1st
      @ITsEasyTraining1st  ปีที่แล้ว +1

      Hi, The first person into the database has exclusive right, everyone else read only until the first person leaves

    • @nikolaradovic1726
      @nikolaradovic1726 ปีที่แล้ว

      @@ITsEasyTraining1st but at first time can two persons to change database at same time