macro with vba forms updated by multiple users in real-time

Currently I have a shared macro that has forms. This macro has add, edit, delete functionality. My problem is that i want multiple users to use it. For example 2 users (1 adding a new record, 1 user updating) or (2 users adding a record at the same time). I have a function that generates id automatically (ex. employeeid), the problem is if two concurrent users add a record the other record will be overwritten. Please help

thanks

You have to be rather experienced with Excel and Excel VBA to overcome the limitations of Excel in this respect. If you are not that advanced you'd better look for another solution. (the most simple one. to use a txt-file that will be opened for writing only and after writing will be closed a soon as possible)

Hi Guys, thanks for the fast reply. Yes I agree. I guess I'll switch to a real database.

You may continue to use Excel as a front end but I would utilize tools that are available such as a disconnected ADO recordset. There may not be a need to redesign your entire project, but only the way the data is updated and perhaps the way it is being stored.