Totally agree. I can't wait for someone to get this right! Many, many enterprise shops spend way too much time building simple CRUD apps. It's basically a "Microsoft Access/VBA" or "FileMaker" for the web.
As far as I'm aware Access can only be used on one local machine, unless you put some networking system together yourself. There's no web-based version either that I know of.
Last time I used Access for anything (at all), you could put the database file on a shared drive and multiple people could use it. This was always clunky though.
That depends on your needs. If you think a desktop Access app is appropriate for your needs, but you want it online, then it would be a good enough solution. It's basically the same thing as in OP.
A desktop Access app is extremely often damn near perfect imho, except for the negative connotation - in my experience, a web app with comparable usability to an access app is typically considered "fcking awesome, but if it is actually an Access app, you'd get laughed out of the room.
The last time I looked at online Access apps, it was a bit of a joke....like ya, you could put individual forms up, but extremely limited functionality, has this changed? (This isn't surprising, making it completely portable would be extremely technically difficult, but has MS somewhat accomplished this?)
