Spreadsheet options

[oaklandar]

I have an Excel spreadsheet (using Office 2000) where I want about 100 people to enter information info into about 25 columns. It will be located on a shared folder that is clicked from a web page.

As many as 5 or 10 people might be accessing this spreadsheet at once to update or add info.
Should I just make 100 spreadsheets to avoid file locking or should I export the data to an Access database to make it more accessible to concurrent users?

Please advise the best way to handle this?

 

[KenWright]

With that many people i would absolutely consider Access better suited than Excel for this, regardless of the sharing options in Excel.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------