multi user, userform data can we store in access db on a realtime with 4 or 5 users

Hello Everyone.

I have created a data entry user form in Excel as a front end, and I want the userform data to be stored in the Microsoft access database at the backend

is it possible that the userform excel can be on a shared mode, and if I save on a local server path, and at a single time 4 or 5 persons can save a new data on the userform....

Will these 4 or 5 new data will reach a database and create new rows.... or will it be overridden on the same row for 5 times..

I am very much confused on this...

Thanks in advance , if somebody can help me really....

Can anybody please help me on the below issue ... as I m not able to understand my self with this concept.