I'm asking for some advice on how best to organize multiple files for a project. Ideally, I would use OneNote but I'm stuck with using OneNote 2010 and it has some draw backs that make it less than ideal for this project. I have multiple users (5-10) working together on one project. The main obstacle that I have is how to organize about 200 files (Word, Excel, & PDF) in a way that doesn't duplicate file versions. We need to have one version for each file but each person needs to add edits to each file AND I need to track the progression of each file to its completion. OneNote 2010 does a poor job of locking the file when multiple users are accessing the same file at the same time so sync errors are possible.
I'm pretty good with Access and Excel but I've not ever used those applications for this type of project. I like Access and I think it is capable of doing this type of project.
Any advice would be appreciated.