I personally would not want to be responsible for security for a web-based Access clone. Enormous attack surface area.
But I think Access is awesome for making and battle-testing prototypes that can eventually become actual CRUD apps. Great intermediate step somewhere in-between e-mailing spreadsheets and building a Rails app, for getting shit done at the office.