I suggest you ...

Build a new better Access

Imagine a client side, pure javascript, SPA web application that displays windowed, data bound forms that talk to SQL Server. These forms are modeled with all of the well though out capabilities of Access forms (same subforms, datasheets, subdatasheets, controls, events, and properties). The development environment is Access-like but Javascript has replaced VBA. SSRS and PowerBI render the reports. SQL Server is the database and the web server, delivering the application through a web port, manages the session/connections, and maintains data. The product comes with SQL Server. Not bound to the cloud, but bound to SQL Server.

5 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    mdk shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Planned  ·  AdminAccess Team (Admin, Microsoft) responded  · 

    We are continuing to invest in Access Desktop, introducing new features regularly.

    Please follow what’s been added to Access 2016 (O365) here:
    https://support.office.com/en-us/article/what-s-new-in-access-2016-76454345-f85d-47af-ace1-98a456cb3496

    You can also view O365 public roadmap and search for new features that are in development
    https://products.office.com/en-US/business/office-365-roadmap

    Another good source of information is the Access TechCommunity space here:
    https://techcommunity.microsoft.com/t5/Access/ct-p/Access_Cat

    Regards,
    The Access Team

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        SUCKS! Microsoft typically across all platforms relies on its "community" to answer questions. It's no wonder a lot of people prefer MAC!

      • mdk commented  ·   ·  Flag as inappropriate

        Well, you'd actually solve my deployment issues if Access for the Mac were released so that 20% of my users didn't have to use terminal services.

        But in the long term, hopefully a goal is to have the Access model of forms rendering in web browsers with Javascript. And not bound to SharePoint, but distributed with SQL Server.

        For an interesting side see databound javascript based controls by: https://www.smartclient.com/smartclient/showcase/?id=Welcome

        And/or maybe someday PowerApps, could have rich forms with subforms etc. and a real language. But right now that environment can't even edit a datasheet - something that Access had in 1.0 when distributed on 3.5" disks back in the day.

      Feedback and Knowledge Base