Multiple Users input data using Excel Userform to a Common Access Master Database

Hi all,

I searched several forums and it is all bouncers for me as I have lost touch with VB in excel. My requirement is I have 2 users, to whom I will be copying the excel workbook in their individual computer which contains excel userform which inputs data like Customer Name, Age, Address, Group, Enroll Date, Pay Mode, Branch, Referred By etc.. fields and I have already created a access MastDat.mdb with the exact fields.

On clicking submit, I want the userform data fields to get saved into the MastDat.mdb. Currently, I am using Excel 2013 at my office and would like to have simultaneous entry of userform data from 2 users to be saved in access.

I am attaching a sample excel 2013 file with a userform to collect data and save to access database. I am getting error while submitting the data. Can anyone help me with the coding and reupload the corrected file. You can download the access database from the link below

Please Login or Register  to view this content.

I would like to know whether multiuser concept is possible, if so kindly guide with the VB code for the same. If this method is not possible, you gurus can suggest me a workaround for the same.