Access to workbook by multiple users

I have developed a workbook that contains an Inputform that captures data and posts the record to a database. The database feeds a dashboard for management info. There are 20 users across the country that need to access this workbook and add new records on a daily basis. The users can dial in to a central server where the workbook will reside. Is there a way to deal with multiple users accessing the workbook simultaneously?
Thanks in advance

Yes, you can share the workbook, but it's generally a bad idea

Is the database an actual database Access/SQL Server/Oracle etc or is it another Excel workbook?

Thanks Kyle123. The Inputform is in sheet 1 and the database in sheet 2 of the same workbook.

Is a shared workbook the solution for this problem?

If I create a shared workbook, will multiple users be able to access the workbook and post records to the database simultaneously? What are the potential problems of using a shared workbook in this way?
Thanks in advance

Shared workbooks don't work particularly well and generally cause more problems than they solve. A much better solution would be to use access

Thanks Kyle123. I would really like to use Excel as I have developed a signifcant amount of code and the model works perfectly. The only problem is the multiple users and I am hoping there is another solution? I suppose each user could have their own workbook and update their own records. At month end, they could send their workbook to a co-ordinator who could consolidate all the workbooks? This is not an ideal solution though?

That would be better than trying to share workbooks, you can automate the consolidation.

Excel is not desinged to be a multi-user environment and really doesn't work well in one. Access can support multiple users, although there is nothing stopping you using Excel as your interface for users and Access as the back end that they never use.

Most of your code should be re-useable, in the above scenario as all you are doing is writing to access rather than a worksheet. Unfortunately this is a common problem and it's just a case of doing research into the best approach before strarting out.

IF you can post a sample of your workbook, I'd be happy to take a look and offer suggestions