Which Access versions do developers use?
As an Access developer, you may wonder whether you are mainstream or exotic with the versions you use. At my German Access developer conference AEK, I have been asking the participants for many years which versions they are currently working with. These numbers are useful for assessing the situation and help me to plan the right topics.
Shockingly, not all participants fill out my extensive questionnaires. I do however get answers from 100 to 150 mostly professional developers, depending on the year and how the event is held. Here are the results after AEK24 in October 2022.
The comparison over the last 5 years shows, unsurprisingly, that the older versions tend to decrease and the newer ones tend to increase. On closer inspection, however, one sees e.g., that Access 2010 is holding up as well as Access 2016. It is still used by 40% of developers. (Most developers work with several versions, which is reflected in the chart.) Or that Access 2021 didn't even get off to half as good a start in its first year as Access 2019. The slight dip this year in Access 365 could be a statistical outlier.
Here are the same figures again in a year-on-year comparison.
You can see that the blue bar of Access 365 only took over in 2021. So for the fact that Microsoft has only been promoting this subscription version for many years, it has taken quite a long time. In 2018 and 2019, Access 2010 was still clearly in the lead, in 2020 Access 2016 had taken over, then Access 365.
Another question I ask: What share does Access have in your current database projects, as backend (=data in accdb/mdb) and as frontend?
It's no big surprise that at an Access developer conference, Access as a frontend tool has always been between 80 and 90% over the last 10 years.
The backend value has been between 40 and 50% for many years. This means that even professional Access developers not only use SQL Server for data storage, but ACCDBs or MDBs in almost half of their projects.
This year, for the first time, the value for the backend has fallen significantly below 40%. The question is: Statistical outlier or longer-term effect of the many Access update bugs that make data storage in Access backends increasingly difficult?
Traditionally, no usage statistics are available for Access. Only dubious popularity comparisons of database systems based on Google searches or mentions in forums etc. pop up every now and then. My statistics are based on relatively low user numbers, but the way they are determined over the long term makes them solid. For us Access developers in Central Europe, the results should be quite representative, and I'll just pretend for other parts of the world as well, because no one else has figures to offer anyway. ;-)