CODEWITHSUNDEEP
excelsqlitems-access
Caveatrob
Caveatrob

Reputation: 13277

Thinking of going SQLIte over Access for a small office Excel app

Client wants to go with Access to aggregate Excel data, but I start wondering - how do I gauge whether Access is to fat and SQLite is just right?

Upvotes: 0

Views: 115

Answers (1)

Mike Sherrill 'Cat Recall'
Mike Sherrill 'Cat Recall'

Reputation: 95612

SQLite is essentially one product. Access is at least four.

  1. Multi-user SQL(ish) dbms
  2. RAD environment for user-interface development
  3. Reporting engine
  4. Programming environment

Law offices are not paperless offices. Reporting is going to be a big deal. And Access has one of the best report generators I've ever worked with, and I've been around a long time. (Too long, some say.)

Upvotes: 4

Related Questions