Our company is currently utilizing Excel and have been encountering a series of issues for starters we have multiple users sharing this application. We utilize it write our schedules for our employees and generate staffing levels. May someone give me please or inform me what are the pros and cons of this program and offer suggestions for another database that allows multiple users to share and also give the pros and cons need something that will hold massive data and allow sharing, protecting capabilities.
Tell me more
×
Programmers Stack Exchange is a question and answer site for
professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.
|
|
|||||
|
closed as off topic by World Engineer♦, Dynamic, ElYusubov, gnat, Doc Brown Sep 24 '12 at 9:36
Questions on Programmers Stack Exchange are expected to relate to software development within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.
|
If you have the skills in-house to manage it, then you want a proper RDBMS. Something like PostgreSQL is available for free and would be appropriate for a medium-size application with a reasonable number of concurrent users. You'll need to write/modify your applications to use a RDBMS. If you don't have the skills then I suggest using something like Google Docs. It's not as sophisticated, but it does work well with a lot of concurrent users (certainly better than emailing Excel spreadsheets around). |
|||
|
|
