Feedback by UserVoice

Access (Desktop Application)

Welcome to the Access Desktop feedback forum! This is the place for users to send us suggestions and ideas on how to improve.
We have partnered with UserVoice, a third-party service and your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

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. Put Pivot Tables back into Access. Surely a database should be able to analyse data, including text fields. This cannot be done in Excel.

    Put Pivot Tables back into Access. Surely a database should be able to analyse data, including text fields. This cannot be done in Excel which can only handle numeric data. Our business uses them extensively and currently we cannot find an alternative.

    324 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      22 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Put the ADP file option back into Access 2013 and beyond...

      ADP's provide a simple connection to SQL server. In addition, Forms and reports have properties that simplify retrieving data.

      95 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        No Current Plan  ·  16 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
      • Deprecate all versions of Access

        I would like to suggest to Microsoft an idea that came to me in a dream last night. My dream was a little bit like:
        I was sitting in a bench at some park, there was no black people around, Donald Trump probably won the reelection. I was reading the news, "Elon Musk dies on his way to the sun"... For some reason I'm not surprised. All of the sudden I realize I was supposed to go to work because its sunday! I rush to McDonalds... on my way I see a massive screen showing the new capabilities of Access…

        6 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          No Current Plan  ·  7 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
        • Warranty expiry field (date) for appliances in the Home Inventory List template.

          Users recording the purchase of appliances for the home may find it useful to note the warranty expiry date of each appliance. It would be handy to have in the event of appliance failure or malfunction.

          1 vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →

            Thanks for posting here.

            At this point we have no plan on updating templates.
            Customers are encouraged to customize existing templates to best fit their needs.

            Thanks,
            Access Engineering

          • VBA Updates

            '~~~~~~~~~~~~~~~~
            VBA Native line numbering
            '~~~~~~~~~~~~~~~~
            Adding line numbers is something that is a pet peeve. Line numbers should be Native and error trappable by default without having to add them manually.

            '~~~~~~~~~~~~~~~~~~~~
            VBA Accessible Call Stack
            '~~~~~~~~~~~~~~~~~~~~
            A way to read from the call stack, function/sub names in order accessed, times accessed...etc

            '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            VBA Custom Toolbars to allow custom Macro/Function Calls
            '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            If I could add my ow custom functions as a toolbar button and have my toolbar exportable and importable for others to use. As opposed to a full Add-In.

            '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            VBA button and/or right click to open…

            23 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
            • Please provide us a utility to create Mobile Apps using MS-Access (Specially for Mobile development)

              Hello Team,
              A mobile app developed using MS-Access itself can help in creating Apps which can be used by a Sales Team which is performing marketing activities in remote locations.
              The mobile app can help the Sales person record the customers enquiry (Very minimum fields) and on a push of a button have it flushed to the Corporate CRM database.
              I'm asking for a Small Mobile App development tool which can help MS-Access run on any mobile (I'm speaking of a very very light version).
              This will not only make MS-Access a versatile product but millions of mobile app developers…

              12 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
              • Enrich VBA, take it out of maintenance mode

                So VBA was put into maintenance mode, Microsoft moved programmers to .NET. That was years ago. Office Desktop apps are still selling with VBA and yet VBA has not been enhanced - the two environments do not compete and I have not seen .NET intrinsically replace VBA and packaged as Office's internal programming language. There are so many ways that VBA can be enhanced. Linq can be added so that we are not typing mutiple quotes in unverified statements isolated in a string. String Interpolation. Managing large chunks of text in strings etc.. etc...

                47 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                • MS Access

                  I would like to have a cloud version of MS Access and really need it for my business could you please indicate a timeframe ?

                  21 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    1 comment  ·  Cloud  ·  Flag idea as inappropriate…  ·  Admin →
                  • MS Access on MAC

                    At this moment I'm a subscriber of Office 365, but always I worked with Ms Access. Now, I have a Mac book Pro and is not possible install it. I also work with other tools, like Excel, but I would like to see the MS Access to be compatible with IOS system, because it's a wonderful tool, and I can't have both systems (Windows and Mac).

                    11 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
                    • fix the new charts in 2016 (eg Waterfall chart) so that they can be modified with VBA.

                      I have been unable to use the new waterfall chart in an application developed in Access. I can create it up but it doesn't allow changes of data or any property by VBA as other charts do. Why would MS create a really useful chart and then not fully implement it? There may be more up to date information on this, but a discussion from a year ago (June 2017) says the VBA hadn't been implemented then and apparently there has been no change. (Or am I missing something?)
                      https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom-mso_2016/are-the-six-new-chart-types-in-excel-2016/3e8f9bf1-76a7-4a1a-91cd-9ed27165c17c

                      1 vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

                        Thanks for trying out Access new charts!

                        However, seems like there is some kind of confusion here as Access doesn’t support a waterfall chart (yet). Also, the answers forum link discusses an Excel waterfall chart.
                        Perhaps your suggestion is in the wrong UserVoice site?

                        Regards,
                        Access Engineering

                      • 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)

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

                          PowerQuery is a great Excel feature which allows users to discover, combine and refine data across a wide variety of sources.
                          Access allows users to connect to a wide array of external data sources in a way that is unique to Access users and scenarios.
                          When we think of data management solutions across Office, we think of Excel and Access as somewhat complementary products, but not competing.
                          With that, duplicating capabilities from one product to another is not supportive of this perspective.
                          We are looking at further enhancing and improving Access’s abilities to connect to external data sources, but not in the form of integrating PowerQuery.

                        • Bring Access to the year 2017

                          OK, enough of COM controls and VBA programming. The controls need a complete overhaul that look like and act like year 2017 controls not 1981 controls. We need more controls that you would find in .net interface. The chart control, datashets and almost all other controls need to be moved out of the COM world. Creating a dashboard in near impossible with the current controls and layout handling.

                          Also VBA is ok but very limited compared to .net. Both are your products why not integrate them.

                          We need a true grid control, better comboboxs, true PDF support, better and attractive…

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

                            Thanks for sharing your thoughts and ideas with us.

                            However as written, we feel that this suggestion is not actionable. Please feel free to create new itemized suggestions that are more actionable.

                            Thanks,
                            Michal [MSFT]

                          • Re-Instate Pivot table view in Access 2016

                            Please restore this feature, clearly by the number of ignored CUSTOMER requests in the past to restore, you clearly dont value your user are are technically unable to honor their wishes !!!

                            3 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              1 comment  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →

                              As you are probably aware, Pivot Charts and Pivot Tables have been removed from Access 2013 because the technology they relied on was deprecated (Office Web Components).

                              Since Pivot Charts as we all know them, will not come back to Access, we are updating the status accordingly and would like to encourage you to continue and use your free votes to support other suggestions.

                              Thanks,
                              Michal [MSFT]

                            • When will Access have a mobile version?

                              I have been using database manager for many years from Smartlist To Go on the palm, to HandBase on Android and now Airtable cross platform Windows, Apple and Android. None of them is as powerful as Access. Really, really needed a mobile version because most of the time I use the database is with my phone. I only go to my computer to look at larger databases. Please let us know when will a mobile version for Android and Ipad come out? please please!!

                              2 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                1 comment  ·  Mobile  ·  Flag idea as inappropriate…  ·  Admin →
                              • You need to get MS Access on the web or it's a dead product......

                                You need to get MS Access on the web or it's a dead product...... MS Access used to be great to make apps on the Local Area Network(LAN) using VBA and (I used) SQL Server. But now people need to get to that same data from the web... from anywhere.... If Access can't be moved to the web(including it's interface, not just database) it's a dead/dying product. I currently use ASP.NET with C# and SQL Server to re-create all that I've done with MS Access but I hate to see MS Access die. There is a drive right now to…

                                1 vote
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  No Current Plan  ·  0 comments  ·  Cloud  ·  Flag idea as inappropriate…  ·  Admin →
                                • Shut down this product

                                  You have no intention to evolve this product nor listen you your customers
                                  So avoid the frustration and shut down the site as well as the product

                                  1 vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • In some Access export commands path length is limited. Could you remove those limitations?

                                    In some Access export commands path length is limited. Could you remove those limitations?

                                    ' works:
                                    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Mitarbeiter", "C:\Users\Gerrit.Viehmann\Desktop\Very looooooooooooooooooooooooooooong directory\Very loooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooong filename.xlsx"
                                    ' Error 2006:
                                    DoCmd.TransferText TransferType:=acExportMerge, TableName:="Mitarbeiter", FileName:="C:\Users\Gerrit.Viehmann\Desktop\Very looooooooooooooooooooooooooooong directory\Very loooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooong filename.txt"
                                    ' works. Add one ‘o’ and it doesn’t:
                                    DoCmd.TransferText TransferType:=acExportMerge, TableName:="Mitarbeiter", FileName:="C:\Users\Gerrit.Viehmann\Desktop\Very looooooooooooooooooooooooooooooooooooooooooong filename.txt"

                                    1 vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →

                                      Thank you for posting.
                                      The limitation in this case is on the filename itself, not the path. For file types, the database engine treats the file name as the table name in an external data source, so it enforces the limit on table name length, which is 64 characters.
                                      At this point we have no plan of changing such a fundamental behavior in Access.

                                    • 3 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                                      • I am a former DBASE programmer. I find that language to be very powerful and yet the language in ACCESS does not support it.

                                        I could create a PRG file that would perform much as an application ...
                                        I am gradually learning the intracicies of ACCESS objects and how to build embedded queries inside of queries. I am also able to build some pretty exotic filters at this point. The Do While Loops coupled with nested If statements in DBASE enabled me to perform some pretty complex real world processing, that I find more n more complicated to replicate using ACCESS. It would be the BEST OF THE BEST if there was a bit of the same syntax as the Ashton Martin - DBASE.…

                                        1 vote
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Please provide a link to datasets to be able to follow along with the MS Access tutorials

                                          I cannot follow along with all the steps given I do not have a dataset to work with that is similar to the tutorials.

                                          1 vote
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →

                                            Thank you for posting.
                                            Most Access tutorials published by Microsoft refer to the Northwind database which is available as a template in Access.
                                            Use the search box in the templates page to search for it if it doesn’t show up in the first page.
                                            You will find this database sample to be highly useful in learning Access and following tutorials.

                                            Hope that helps,
                                            Michal [MSFT]

                                          ← Previous 1 3 4 5 6 7
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base