3 ms·
I loved what Access represented, but loathed what it was. I've yet to encounter a web-based tool that allows you to quickly build a relatively complex database
by bradleyland 15y ago
I loved what Access represented, but loathed what it was. I've yet to encounter a web-based tool that allows you to quickly build a relatively complex database with the ease that you could with Access. I've tried a lot of tools, but the one thing missing from most of them is the relational aspect. Access had great tools for relational data:
* Easy creation of [FORM [SUB-FORM]] constructs
* Easy linking of dropdowns and lists from table or view data
* Simple GUI for creating forms
* Intuitive data binding behavior
* "Wizards" for common tasks that require guidance
What sucked about Access was the back-end. Using an Access database over a network meant sucking huge chunks of data over the wire. I built a few Access databases with a SQL back-end, and use over a network wasn't all that bad.
And yes, I'm aware that my views are probably wildly unpopular with developers, but I live in a world with business users. Anyone want to venture a guess at the number of business users out there who are literally building databases out of Excel spreadsheets? I know plenty of people for whom a SQL "LEFT INNER JOIN" would make no sense, but they're perfectly happy using an Excel workbook full of tabs and VLOOKUP() calls all over the place.
ZoHo has a product called Creator that comes close, but when I tried it (a year or two ago), the "relational" aspect was missing. The master->child data relationship exists everywhere in business processes, but there are no user facing tools (except Access and Excel) that put the power of relational data in the hands of users.
I miss what Access could be.