Share via

A Vision for Modernizing Microsoft Access - A Proposal

Anonymous
2024-12-08T14:40:16+00:00

A Vision for Modernizing Microsoft Access

Dear Microsoft Access Team,

As a longtime user and admirer of Microsoft Access, I’d like to share some ideas for modernizing and future-proofing this remarkable tool. Access has been a cornerstone for database-driven applications, but I believe it has the potential to reach new heights with the following updates:

  1. Upgrade Forms to HTML5 + CSS
    Replace the current forms system with HTML5 and CSS, allowing for responsive and adaptive designs. This change would enable Access applications to function seamlessly across desktops, tablets, and mobile devices, enhancing versatility and usability.
  2. Support for JavaScript as a “Code-Behind” Language

In addition to VBA, introduce JavaScript as an alternative for coding. JavaScript’s modern ecosystem and developer familiarity would attract more users and open up new development possibilities.

  1. Modernize Reports with HTML5 + CSS

Update the reporting system to output results in HTML5 and CSS. This would provide greater flexibility for customized designs and make reports compatible with web and mobile interfaces.

  1. Reintroduce Application Splitting and Deployment

Reinstate and enhance the ability to split databases into a back-end and a front-end application. Allow developers to export front-end applications created in HTML5, CSS, and JavaScript for hosting on web servers like IIS or deploying to the cloud.

  1. Cross-Platform Portability

By adopting technologies like HTML5, CSS, and JavaScript, Access could be made portable across platforms, including macOS. This would address a long-standing demand from Mac users while opening up new markets. Making Access cross-platform would further solidify its position as THE premier database development tool.

  1. Standalone Application Compilation

Introduce a feature allowing Access to “compile” applications into standalone executables or deployable packages using a web server wrapper. This would allow apps to run without Access being installed, eliminating the need for an “Access Runtime Edition” and simplifying deployment.

  1. Launch (again) an “Access Developer’s Edition”

Create a dedicated Access Developer’s Edition, sold separately from Office, with advanced tools tailored for developers. This edition would serve as a powerful but accessible alternative to Visual Studio, focused on creating portable, platform-independent database applications.

  1. Flexible Integration with Office

While keeping Access standalone, provide optional integration with other Office apps through exposed libraries. This would give developers more control over how they interact with Word, Excel, and Outlook, or not at all if the goal is to be fully portable.

These updates would not only modernize Access but also position it as the go-to tool for lightweight, platform-agnostic database development. With cross-platform potential and standalone application capabilities, Access could meet the growing demand for versatile, efficient, and independent database solutions.

Thank you for your time and for considering these suggestions. I’d love to hear your thoughts and discuss how we, as a community, can help shape the future of Microsoft Access...

Or is this the recipe FOR THE REPLACEMENT of Microsoft Access? ;-)

Sincerely,
Fabrizio

An Access Developer since version 1.0

Microsoft 365 and Office | Access | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-12-17T02:21:26+00:00

    Hello Fabrizio,

    this is a never ending discussion about managing the expectations imo. Not really about the software.

    Almost all what is listed is already addressed elsewhere, except the #8.

    I see a few contradicting points tho. Asking for a cross-platform and a standalone application tells me

    that the app is shipped as a source code or a single package compiled for ALL platforms out there.

    Including Apple Macs. But than, the expectation is to run html, JS, and some sort of backhand language, typically VBA, so you would reuse the existing programming knowledge.

    And this is where the story ends, I'm afraid. Because what's missing here is the Web Server. For such software, all good Web servers should be supported. And none of them are VBA compatible. Even with Python as a backhand language, all Web servers are somewhat limited since most of them mount the application to the root of the Web application.

    Hence, retaining Access with a VBA would give what exactly on the Web browser? Nothing. And the Web browser does NOT integrate with the Office suite for a good reason.

    It is the security of the platform which is totally exposed if the Web browser integrates with any Office suite.

    As others mentioned, it is already possible to expose Access data on the Web. That is, if Access database is used. If MSSQL is used, than the World is your oyster.

    0 comments
  2. George Hepworth 21,805 Reputation points Volunteer Moderator
    2024-12-17T14:17:23+00:00

    What in the world is "... an air gaped environment"?

    0 comments
  3. Duane Hookom 26,280 Reputation points Volunteer Moderator
    2024-12-17T14:30:25+00:00

    I expect it’s “air gapped” which means isolated from about everything such as networks and the internet. We had some similar requirements when I worked for a food manufacturer.

    0 comments
  4. George Hepworth 21,805 Reputation points Volunteer Moderator
    2024-12-17T15:42:04+00:00

    A difference of one p. 🤔

    Got it.

    0 comments
  5. George Hepworth 21,805 Reputation points Volunteer Moderator
    2024-12-18T13:14:47+00:00

    Seriously, at first I had this mental image of a database user gaping out the window into empty space, wondering why their database no longer worked.

    In the age of autocorrect, one still can be led astray.

    0 comments