Hi,
we have more than 5 users who need to add data to an excel sheet but as everyone knows it will allow only one to modify and the others shall be read only.
Sharing the workbook is not good either as if 2 users have modified the same cell they shall be able to bothe save their datas.


i was told access can help me design a form which will link to the excel sheet.
The sheet will contain the excel headers and the users can input the data without knowing in which cell(row) being used.
The access shall insert the data in the first free row and the next entry is done on the next row.
Any ideas how to do that?
please note that my excel book already has 400 row occupied.