Like everyone with significant Microsoft experience I've done some Access Applications.
The reality is, I'd prefer to do it in Rails. Ruby on Rails let me gain the power of using
any ruby gem or rails plug-in. I have access to practically every database in Rails.
And I have access to nice Menus as well. Plus the ability to define a web api,
For me, for a small app, I can host it as a windows service directly on Windows with Mongrel. I can
use single sign-on, so if your in the domain, your automatically authenticated. Using role-requirement,
I can define user roles, and even have dynamic menus.
Even better I can use PRAWN or Pdf::Writer to directly generate reports. Or Scruby to scrape web pages.
And Add to the Data on the fly.
The other thing I've seen with Access applications, it too easy to get the file locked by one user, and
no one else able to access it. Scaling on Rails is Easy compared to Access. And on top of all of this is
easy cross platform functionality.
The nice thing is that the language of Rails is Ruby. And Ruby is significantly easier and faster to develop on than VBA.