For example, Microsoft with new versions of MS SQL Server says that the cost of requests decreases, productivity improves and so on (that is, everything is cool), but I have not seen anything like this about new Access.

Actually the question is, is there any development in terms of performance in Access databases or not?

I happened to use 2007,2013,2016 and as they stopped on requests which swallows with a bang MS SQL and stops.

It seems to me that Access still does not exploit the potential of multi-core processors.

Even the allowable size of the database with 2GB does not increase.

Closed due to the fact that it is necessary to reformulate the question so that it was possible to give an objectively correct answer by the participants aleksandr barakin , fori1ton , user194374, Streletz , Nick Volynkin ♦ Jul 12 '16 at 7:09 .

The question gives rise to endless debates and discussions based not on knowledge, but on opinions. To get an answer, rephrase your question so that it can be given an unambiguously correct answer, or delete the question altogether. If the question can be reformulated according to the rules set out in the certificate , edit it .

    2 answers 2

    Access is a SOHO - solution - for home and SMALL office, it is not intended to support huge bases. And if so, then there is no point in putting R & D efforts into it.

    • Well, MS should attract people to their product. I look at the latest offices and apart from changing the interface I don’t see really useful features ... - iluxa1810
    • four
      Access is in some way a legacy product that is dragged into new versions of the Office package so as not to miss the client. And push him a new version of Office. Those people who program on access, in fact, arrange a terrible setup for operators. It is better to switch to alternatives like msde or sqlite - gecube
    • The @gecube "setup" for operation begins from the moment the window vent is tied into the server processes. - gbg
    • @gecube, Access has many +. For example, many things are available out of the box, a friendly interface for those unfamiliar with SQL users, you can make the missing functionality on your knee. Since the interface is friendly, you rarely need to cut the interface for user interaction with the database. - iluxa1810
    • 2
      @ iluxa1810 libreoffbice base? - gecube

    I think that you are right and how MS Access DBMS has not been developing for 10 years already.

    But why actually develop it? The movement goes towards mobile, where there is MS SQL Compact as a database. Another development direction is web applications, but there is quite a wide choice in the database part.

    Here is the document in which Jet 4.0 is declared obsolete: https://msdn.microsoft.com/en-us/library/ms810810.aspx

    • Like, new Access work through ACE 12.0. - iluxa1810 8:50 pm