How to split a Microsoft Access Database and create multiple users.
Ғылым және технология
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
How to split a database and have multiple users. Checkout courses at www.itseasy.co.uk
most helpful video ever
@ITsEasyTraining1st
5 ай бұрын
Glad you think so!
*_Very nice vid my friend! Really enjoyed, thanks for sharing! Keep up the great work! :D_*
@ITsEasyTraining1st
3 жыл бұрын
Thanks
Thank you great tip 👍🏽
@ITsEasyTraining1st
3 жыл бұрын
Thanks
Lot of Thanks Sir!.....
@ITsEasyTraining1st
2 жыл бұрын
Most welcome
Excellent!!
@ITsEasyTraining1st
Жыл бұрын
Thanks
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
2 жыл бұрын
It sounds like a network issue. Are both files open at the same time? Check where the database is stored.
@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.
how can you open multiple front ends one once? We can only open one front end at a time.
@ITsEasyTraining1st
2 жыл бұрын
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
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
Жыл бұрын
Hi, The first person into the database has exclusive right, everyone else read only until the first person leaves
@nikolaradovic1726
Жыл бұрын
@@ITsEasyTraining1st but at first time can two persons to change database at same time