Feedback by UserVoice

I suggest you ...

Better integration with SQL Server

Install SQL Express alongside Access and make SQL Server the default database format instead of ACE. With a SQL Server database Access could and should support all the features it currently supports with ACE. Integrating SQL Server in that way would enable a much greater range of features and use cases to be supported out-of-the box.

228 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    nto shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    28 comments

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

        I really miss ADP! But I am encouraged by the few ODBC improvements I've seen, such as easier re-linking, etc.
        But could you PLEASE, somehow, re-introducing (through ODBC or other method) the ability to use stored procedures in forms, with arguments. (Just like ADP did)?

      • Kerstin Malz commented  ·   ·  Flag as inappropriate

        Porsche ist die Sportwagen-Tochter des VW-Konzerns. Aber Porsche ist auch der Name der Holding, die die Stimmenmehrheit an Volkswagen hält und damit quasi die Muttergesellschaft der Wolfsburger ist. boerse.ARD.de erklärt.

        Um die komplizierte Beteiligungs-Struktur zwischen Porsche und VW zu verstehen, sollte man mindestens ein Jahrzehnt zurückblicken. Denn im Jahr 2005 begann Porsche mit seinem damaligen Vorstandschef Wendelin Wiedeking, eine Beteiligung an Volkswagen aufzubauen und stetig zu vergrößern.

        Strategisch wurde dies mit möglichen Synergien zwischen beiden Unternehmen in der Produktion, aber auch mit der Abwehr einer möglichen feindlichen Übernahme des VW-Konzerns begründet, die die Gründer-Familien Porsche und Piëch verhindern wollten. Der Anteil wurde von fünf auf zunächst fast 30 Prozent ausgebaut.
        Integration statt Übernahme

        2007 erklärte Porsche, einen Mehrheitsanteil an VW anzustreben. Bereits in diesem Jahr wurden die "zwei Porsches" geschaffen. Die Porsche AG war für das operative Geschäft, also den Bau der Sportwagen zuständig. Die Porsche Automobil Holding SE (Europäische Aktiengesellschaft) agierte als Manager der VW-Beteiligung. Über spektakuläre Kredit- und Derivate-Geschäfte sicherte sich Porsche 2008 die Option, sogar 75 Prozent an VW zu erwerben. Ein Jahr später einigten sich beide Parteien aber auf die Schaffung eines "integrierten Automobil-Konzerns".
        Porsche AG wird bei VW eingegliedert...

        Dabei übernahm Volkswagen zunächst 42 Prozent der Anteile an der Porsche AG, der kurz darauf auf 49,9 Prozent ausgebaut wurde. Die Mehrheit der Anteile blieb noch im Besitz der Porsche Holding SE. Im Jahr 2012 wurde dann die heutige Struktur zwischen Porsche Holding, Volkswagen und der Porsche AG geschaffen: Für 4,49 Milliarden Euro kaufte VW die restlichen Anteile an der Porsche AG und gliederte sie in ihren Markenverbund ein (siehe Schaubild). Die Porsche AG ist also nicht mehr börsennotiert. Die Porsche SE wiederum hält 52,2 Prozent der stimmberechtigten Stammaktien von Volkswagen, das entspricht 30,8 Prozent am gesamten Kapital bei VW. Die Porsche SE ist also gewissermaßen Herr im Hause VW und die Muttergesellschaft von Volkswagen

      • Anonymous commented  ·   ·  Flag as inappropriate

        This should include supporting all SQL Server datatypes, the same SQL language, real SQL parameter support, rules, etc...

        And don't stop there: match SQL Server terminology, like Views instead of Queries. If you take this far enough, you could dump both JET and ACE. That said, we don't want a copy of SQL Server added to the package.

      • Lightwave commented  ·   ·  Flag as inappropriate

        If this could be done without losing the single file based database approach fine if not this would be a dangerous and very destructive move in my opinion. Having a single file that is directory agnostic and completely transportable is a real competitive advantage that provides something that web databases/professional database engines don't and can't provide - Its what make MS Access MS Access. It would be a really dumb thing to get rid of that and move to all the hassle of a scratch pad riddled with dependencies. By the same logic you could argue that you should get rid of notepad in favour of word. Get rid of BMX's in favour of mountain bikes and I should probably have either a steel strung guitar or a Spanish guitar but not both.

        Single file based approach would require Ace being incorporated into SQL Server mdf format! Hell will freeze over before Microsoft do this :)

      • Steve Goldring commented  ·   ·  Flag as inappropriate

        The best answer to this suggestion is MSOLEDBSQL against SQL Server in the cloud. Very big news that this data technology is back in focus. Testing so far indicates significantly better performance compared with ODBC Driver 13 for SQL Server

      • Dolly commented  ·   ·  Flag as inappropriate

        It makes no sense to bog down PCs with SQL Server uselessly by default when the vast majority have no need for it and in the cases where it makes sense, the ability already exists to install the Express edition (for free) and leverage it. To me, this suggestion is a no go and if I could vote against it, I would. I don't think MS wants to go down the avenue of shoving SQL Server down people's throats.

        SS has it's reason for being, but making it the default with Access, I'm sorry, NO!

      • Dolly commented  ·   ·  Flag as inappropriate

        If you want SQL Server Express, install it, no? It is freely available. Simply download it (https://www.microsoft.com/en-us/cloud-platform/sql-server-editions-express) and install it. You can interface Access with it right out of the box.

        Since it is a separate program on its own, it make no sense that it would be installed as part of Access. Furthermore, the vast majority of users use Access as is on its own. It would make no sense to go and install SQL Server Express and thus bog down their systems for no reason with useless services and the likes!

        If you want it, it is but a free download away, but it makes no sense to include it as part of Access.

      • wilo commented  ·   ·  Flag as inappropriate

        some Performance issues while connecting to SQL Server could be improved. Actually the heavy Network load due to permanent locking actualisation leads to slow querys.

      • Anonymous commented  ·   ·  Flag as inappropriate

        SQL Queries in Access are more advanced than SQL Server as as you can declare an expression and use in other other expressions. I do like the idea of Views in SQl Server but Access has Form ware whilst SQL Server is a back-end database.

      • Detlef Traum commented  ·   ·  Flag as inappropriate

        I don't agree with the opinion "ADP was the wrong solution for the wrong problem." In my Opinion ist the change to ODBC a step back. I did not find any convincingly argument for the removal of adps. What do i not understand? Don' know, after 3 Years of investigation ...

      • Christopher Cookson commented  ·   ·  Flag as inappropriate

        I don't think SQL Express is necessarily needed, as with increasing cloud data usage, there's a strong case for SQL Azure if you need multi-user capability, but want to retain the rich client capabilities that Access desktop has over Access web apps.
        It would be nice to have a 'Publish to SQL Azure' option.

      • KVD commented  ·   ·  Flag as inappropriate

        The ability to connect to a SQL Server back end, (either full blown or the Express version), is there now and has been there for some time; this should continue. Closer alignment between MS Access and SQL Server in terms of rules, data types and so on is a very good idea. Having an upsizing wizard that works almost always is a third good idea. However ...

        Still think SQL Server as the DEFAULT BACKEND is needlessly rocking the boat. It is a layer of complexity that is simply NOT needed.

        For my clients, I do NOT supply run time versions or MDEs. They get the source code (with passwords as needed). This is one of my selling points ... nothing is hidden. If my rates do not satisfy them or if the client thinks I am not sufficiently responsive, they are free to engage someone else. In 25 years I have not lost a single client for this reason and have not had a mission failure in a non-run time, non-MDE environment. I think using SQL Server as a DEFAULT backend is a bad idea.

      • nto commented  ·   ·  Flag as inappropriate

        As George has said, SQL Server is completely free to install and use and bundling it with Access should not imply any increase in cost for anyone. A valid point however is that installing it by default wouldn't be appropriate for users who already had SQL Server. There ought to be an option to use an existing copy as well as to install a new one.

      • George Hepworth commented  ·   ·  Flag as inappropriate

        @KVD. There is a free version of SQL Server. It is called SQL Server Express. You can actually deploy a small production database with Access and SQL Express--with licensing only for the developers' copy of Access. The backend is free of licensing costs. You can deploy the Runtime version of Access for all users.

        That said, I'm not sure I'd want to make SSE the default backend for Access, but it ought to be relatively straightforward to make it an alternative for those who want it.

        I'm not going to vote for this one as other suggestions seem to warrant more attention (IMO). But cost just isn't an issue here.

      • KVD commented  ·   ·  Flag as inappropriate

        To respond to nto, I just looked on Google under "SQL Server prices". The product ain't free. Sure you can get a SQL Server desktop for $64 but it may not be handed out to your clients. The enterprise copy is $7,000 plus. There are less expensive variants (hard to understand limitations) minimum of $2500, but they all come with a per core charge. Access 201x by itself is approx. $120, as a part of Office 201x Professional it is included.

        This begs the question, why should SQL Server be the DEFAULT backend? If you and your clients want that knock yourselves out. That capability has been around for a long time. I vote AGAINST MS SQL Server as the default backend, not only for price reasons, but also because of my fear that MS will make it very hard to use another Access database file as a backend - no matter what they say up front.

      • Kent Gorrell commented  ·   ·  Flag as inappropriate

        My two cents - ACCDBs should be more closely aligned with SS.

        For example, When upsizing data from Access to SS you often find all sorts of rubbish data that Access allows but SS won't.

        Applying the same rules and more closely aligning data types would make the migration easier. And this includes preventing bad field naming in Access as well as bad data.

      • Karsten commented  ·   ·  Flag as inappropriate

        Please do not bundle the installation of SQL Server whatever edition to Access. This only makes (limited) sense in a desktop scenario. But it's a complete overkill in a multiuser scenario where a lot of people uses an Access frontend to access a central (SQL/whatever) Server.

        But a better integration would be nice.

      ← Previous 1

      Feedback and Knowledge Base