New answers tagged

4

I've shied away from Access because my team is not comfortable using SQL and overall dislike the Access Interface. Here's your answer. There is a strong argument to use Excel because it is what your team is comfortable with, and that is pretty darned valuable. But managing multiple workbooks (with changing names) has already created several version ...


2

The datamodel is (mostly) independent of the database. Excel is not a database. Ms Access is a great RAD (rapid app devel) frontend, but db (MDAC/Jet) is limited on multiuser, security and backup (no dumps, binary log, etc), but fast and no db-server needed! You can work with Excel, but fetch data from a db (company enviroment Sql Server, MySql, Postgre ...


Top 50 recent answers are included