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

      645 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        52 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]

        • 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 →
          • 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…)
              0 comments  ·  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]

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

                        • provide an offline trial install of individual office products. Not everyone can just sign up for free trials of office365

                          Seriously. Not everyone can just dish out a credit card for a trial of office365.

                          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  ·  Flag idea as inappropriate…  ·  Admin →
                          • provide an offline trial install of individual office products. Not everyone can just sign up for free trials of office365

                            Seriously. I should be able to install a trial without having to dish out a credit card.

                            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 →
                            • Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt

                              i have developed a application with help vs2010 & access2013 it works fine after i update office 365 im facing so much of issues with application like microsoft oleb 12.0 is not registered on the machine and then i installed 2007 and 2010 driver components after the issue is went off & now i got new issue like cannot open database" please help me to fix it

                              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…)
                                0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →

                                Please use appropriate support channels or in product feedback to report bugs and issues you have with your apps.
                                This is a platform for suggesting new ideas.

                                Thanks,
                                Michal [MSFT].

                              • VBA string variable can not handle strange characters, Long text field (Memo field)

                                A VBA string containing a long text variable should be able to be handled in VBA without reading the variable content as part of the string.
                                For now Access vba apparently reads the variable content, and a long variable (string) contains odd characters it either gives an error or populates the variable text truncated.
                                The only way today handle such long text strings with odd characters is unfortunately enforcing use of ADO 3.6 Library and using late binding and record sets, then access vba do not read the variable content as part of the string.

                                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 →
                                • Add the following ability to Power BI Desktop

                                  Add the following features to Power BI Desktop

                                  1) Update tables (via Code, Copy paste, by typing data etc)
                                  2) Password protect PBIX Files
                                  3) Allow Excel to connect to the Data model in Power BI Desktop file
                                  4) Introduce a UserName Function in Power Query
                                  5) Retire Access

                                  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 →
                                  • Please restore the Pivot Tables to MS Access 2013

                                    Many people in my off use the pivot tables that I produced in MS Access, since the change they are now just useless datasheets. I can not expect the staff in the office to export the data and convert it to pivot tables in MS Excel. Please return this feature ASAP. Thanks

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

                                      We realize that Pivot Tables and Charts have been a great feature and many Access users found them to be highly useful.
                                      As you may already know, they have been removed as the technology they relied on, was no longer supported (Office Web Components).

                                      At this point we have no plan to bring Pivot Tables and Charts back. However we are looking into ways to improve and modernize data visualization in Access.

                                      Stay tuned.

                                    • Ctrl+A in a textbox should select all text instead of all records

                                      Currently, when I'm in a form's textbox and I instinctively hit Ctrl+A to select all text (just like any other Windows application), nothing happens. Or so you may think, in fact everything happens! All records get selected, and if you dare hit the wrong button while you think you have selected all text of the textbox, woe is unto you.

                                      Should Access really be different from all other programs out there? Why should a user think that when in a textbox and hitting ctrl+A it won't select the text?

                                      Of course, there are workarounds (like a VBA function that hijacks…

                                      4 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 →

                                        Thanks for suggesting and supporting.

                                        We agree that this behavior is somewhat misleading, but believe that fixing it may cause existing apps and solutions that depend on this behavior unexpected issues.

                                      • HURRY UP AND MAKE ACCESS ON MAC!!!!!

                                        Mac needs an amazing database software and time and time again, you still don't create a version for Mac! MS Remote Desktop is not ideal when you need to use Access all the time! Look at everyone on Mac that is suffering. JUST MAKE A MAC VERSION.

                                        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…)
                                          2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • 7 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  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 6 7
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base