You are reading a single comment by @Oliver Schick and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Oliver Schick
I need to do a form of traceability matrix for a project that involves many-to-one relationships between at least 4 entity types (business goals, initiatives, problems, systems). Maybe a few hundred entities in total. It's new data to be keyed in, not from existing sources. I suspect at least one of those relationships will be many-to-many, once I've looked hard enough.
I realise the solution is a database, not Excel. Previously I've been able to call in favours from IT people (I'm not in IT) and get a small MSSQL or Oracle application put together.
Right now all we have is desktop Access. Which I'm deeply mistrustful of by reputation. So the actual question is - what's likely to go wrong if I do?
If this was a personal project, I'd probably do it in Python+SQLite+Flask (or maybe Django). But I don't have those at work.
I guess Sharepoint's sort-of-database tables might possibly be able to do it, but Sharepoint.