Access (Desktop Application)

I suggest you ...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Add PowerQuery to ACCESS

    PowerQuery is the best improvement for collecting data for Excel since many years. I would love to use it in Access too, without using Excel.
    I would like to extract data from SAP, WEB, CSV-Files, collect all files from a folder, de-pivot files... Any ETL job PowerQuery supplies für Excel, but directly in Access!
    (I posted this two years ago using other words)

    588 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      47 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • data connector sql server

      ADD SQL SERVER AS A DATA CONNECTOR - The Access team is currently evaluating the use of data connectors in Access, (https://youtu.be/j5UAv4yY5RY?t=2155), and we need your support to get them to include SQL Server as an option! PLEASE VOTE for this idea, every vote counts!

      547 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        44 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • Incorporate Power BI as an Add-in to New version of Access 2017

        Since Pivots & Charts have been removed from Ver 2010 onwards, its been a big problem for us consultants to provide charting and pivoting features to our customers. These are features simply adored by our customers due to their ease of use. But after looking at Power BI I feel since its from the same Microsoft family the Access Team should consider incorporating it in their Next Product Planning process.

        471 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          29 comments  ·  Flag idea as inappropriate…  ·  Admin →

          Thanks for posting and voting.
          Integrating Power BI with Access is one of the things we believe will add value to Access developers and users. We are looking into ways to support that.
          Keep voting if this is important to you – it will increase the likelihood of it getting in the product.

        • Provide a native Treeview control

          The Treeview control is an extremely powerful way to display related and hierarchical data in a nodal fashion. I have built application for years using the vb Treeview common control. These applications could not be successful without it. There is certain data such as a computer folder and file structure that would be nearly impossible to comprehend without it., However, the non native Treeview require serious knowledge of Access and VBA to use successfully. Also portability has always been a problem. A native control with some features that make binding data simpler (possibly a wizard), would really expand what the…

          458 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            27 comments  ·  Flag idea as inappropriate…  ·  Admin →

            We are actively looking at providing a native tree view control.
            Please continue to vote and provide more info – scenarios, examples and requirements will all feed into our exploration.

            Thanks,
            Michal [MSFT]

          • Improve Access programmability

            There are many new technologies available that Access cannot take full advantage of because it's either in .NET or requires JavaScript.

            Excel has a JavaScript API being developed and expanding. Using JavaScript would allow for richer integration between desktop and web apps where appropriate.

            On the other hand, native access to .NET framework would provide access to many other components that Access can leverage for automation.

            What we can't do is just stay behind in COM world - COM ecosystem is shrinking and we need a solid integration support especially when our Access application only requires a small part to…

            427 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              Under Review  ·  11 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
            • Provide a native grid control similar to the visual studio gridview or even the old flexgrid.

              A grid control provides the means to show tabular data. Some features include
              - Sorting by column
              - Moving columns by dragging
              - Selecting individual cells
              - Formatting individual row, columns, or cells
              - Control columns such as checkboxes for selecting a row
              - Edit cell of data
              - Spreadsheet type movement

              The capabilities provided by the Visual Studio gridview is a great example. The features that this provides are far beyond what is capable in Access especially when dealing with unbound data. A common example that I see on the message boards is a user want to build a…

              291 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                11 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Please update the look and feel of Desktop forms and controls

                I have not found an alternative to developing in Access for creating custom desktop software for small businesses. All of the other options require 2-3 times the development time for the same functionality.

                The forms and controls in Access Desktop need a facelift. Its been quite a while since you've done anything with them. Please update them.

                255 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  Under Review  ·  10 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Fix form border widths in Access 2016 under Windows 10

                  I don't know if this is a general problem with Office 2016, or if it is specific to Windows 10 users, but I find that sizable MDI forms in Access 2016 have a single-pixel border that is very hard to grab with the mouse.

                  The form borders show as a single-pixel red line, and have no difference in appearance regardless of the mode of the form, whether the mode is "no border", "dialog", "sizable" or "thin". The border appears the same in design mode.

                  I've tried this on a couple of different computers running Office 2016 under Windows 10, and…

                  227 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    71 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →

                    I apologize for an honest mistake with updating the status to Done.
                    We did fix a similar issue with Query design and Relationship window, but haven’t fixed this one.

                    Again – sorry for the mix-up.

                    Michal [MSFT]

                  • Zoom ... Design View for Forms/Reports and Form View, Report View

                    It would be really nice to ZOOM the Design View for forms and reports ... and also Form View, with a slider.

                    For example, Print Preview has a zoom slider in the lower right.

                    Also, Report View should be able to interpret Ctrl-Mousewheel since so it can really be more like a web page

                    198 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      5 comments  ·  Flag idea as inappropriate…  ·  Admin →

                      Thanks for posting. We’ll look into this as we are planning our future investments in Access.
                      I’d like to encourage people to keep voting if it’s something they really want to see the priority raised on.

                    • Enhance the SQL Editor

                      Some features would be good to developers:
                      1) Tabbed SQL Query Windows - allow user to create a query window without binding to a query object (like we do in SQL Server)

                      2) Format the query field with highlighting, identation, colors and make possible to even resize the font size. .

                      3) Allow intellisense to get [table].[field] list (in A2013 we have it in Query Designer but no in SQL mode)

                      4) Split the window in SQL Query and result pane - and make it possible to see result in table or text format (like we have in SQL Server).…

                      191 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        5 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
                      • 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.

                        177 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          20 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • Enable seamless integration with Excel objects

                          In light of the items requesting return of Pivot*** objects (https://access.uservoice.com/forums/319956-access-desktop-application/suggestions/10284183-add-pivot-charts-back-to-access) being rejected, I want to suggest an alternative that I hope is much simpler to implement and would bring better experience:

                          Ability to seamlessly embed Excel objects, be they tables, charts, pivotcharts, pivottables, directly inside Access.

                          This already exists but it is very awkward, outdated, and includes unwanted things (e.g. Excel's chrome, the spreadsheet itself and so forth). This solution should allow us to define an Excel object using Access data and show it as if it was just a normal Access control. It should allow us…

                          171 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            8 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • 162 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              16 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • Automatically resize MS-Access Applications

                              A major problem in the distribution of MS Access applications is the lack of scalability. Controls are not automatically adjusted depending on the particular resolution in Windows.

                              158 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                7 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • Better integration with SQL Server Azure

                                Web app are too limited to build any kind of complex solution, but Access 2013 web apps are built on SQL Server Azure which is pretty solid. Leverage the relationship with Azure and add features to the existing desktop apps so that they play nicer with Azure databases. Things like the ability to create an Azure databases from within Access, an easy way to upsize existing MDB/ACCDB tables, a native AutoComplete control, etc.

                                The best part of this is you can monetize it from the start. You need a way for people to create a small sample database for free…

                                145 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • Switch between objects with Ctrl + Tab

                                  In previous versions of Access it was possible to switch between objects with Ctrl + Tab. Please reactivate this feature. Strg + F6 is not an ergonomic shortcut.

                                  137 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    Under Review  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Make Access a better ODBC client

                                    Given that the trend is toward ODBC and away from OLEDB (ADO), there are number of gaps still present in Access as an ODBC client:

                                    1) support for asynchronous operations
                                    2) support for processing multiple resultsets
                                    3) support for streaming large results
                                    4) support for updating complex data sources (e.g. binding to a stored procedure and then specifying which stored procedure to call to perform insert/update/delete)

                                    and other features that has been added to ODBC (currently at v3.8) but is not available via DAO.

                                    This is necessary to enable Access to transition away from ADPs, better leverage remote data sources…

                                    125 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      10 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Please make Access able to handle more data types as are commonly used in Server databases

                                      For example Access cannot handle BigInt in linked tables. This has been in use in SQL Server for many years, but Access can't handle them in linked tables.

                                      123 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        29 comments  ·  Flag idea as inappropriate…  ·  Admin →

                                        Thanks for this suggestion – obviously there are several data types that are missing and we’ll need to prioritize, so we’d like to get a better sense of what’s most important to you.
                                        Fell free to add in comments – which data types would you like to have supported (in order of importance)?
                                        Thanks!

                                      • Allow Update of Linked Excel Worksheet

                                        The patent preventing this was taken out in the early 1990s so it should have extinguished by now.

                                        Given that this would make Excel much easier to use for charting, which Access no longer has, it would seem time to re-implement this ability.

                                        Preferably with better control over column data types.

                                        116 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          6 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Please allow users to disable the hyperlink popup that says "Some files can contain viruses or otherwise be harmful to your computer..."

                                          Please allow for users to suppress this popup, it's an incredible annoyance when you have to click it hundreds of times a day.

                                          106 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            11 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 31 32
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base