So, my requirements need me to distribute a VBA userform excel file to different people in my organization, and a single database file which will be kept in a network drive (or any other shared location).
I have tested it and it works fine. To save the entry, it downloads the database from network location, saves the inputs from userform and then closes back the file.
My only concern is that what if multiple people are filling the userform at the same time and pressing the submit button. Will all the information get recorded on database or some entries might get lost?
Please guide me on this, and suggest me any thing that needs to be done.