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)

    645 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…)
      50 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
        I agree to the terms of service
        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
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  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
            I agree to the terms of service
            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
              I agree to the terms of service
              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
                I agree to the terms of service
                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
                  I agree to the terms of service
                  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
                    I agree to the terms of service
                    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
                      I agree to the terms of service
                      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
                        I agree to the terms of service
                        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
                          I agree to the terms of service
                          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
                            I agree to the terms of service
                            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].

                          • 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
                              I agree to the terms of service
                              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
                                I agree to the terms of service
                                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.

                              • 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
                                  I agree to the terms of service
                                  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
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                  • 8 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…)
                                      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Please bring back Dynamic Charts and Pivot Tables

                                      Hello, some of the features that have been dropped on Access from the 2013 version is a frustrating fact.
                                      Specifically, I'm talking about the PivotTables and PivotCharts.
                                      I developped for my company two applications that manage the commercial activity and another for the management of operational risks.
                                      This feature (PivotTables and PivotCharts) had been very useful for reporting in the 2007 and 2010 versions.
                                      Now this feature is no longer supported and our IT Department has migrated the Office to the 2016 version, I am really stuck.
                                      Please take into consideration this request and consider the possibility of its reactivation.

                                      96 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…)
                                        3 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.

                                      • Mac Office 365 pricing - Why am I paying for Access & Publisher??

                                        Mac users cannot download Access or Publisher, but we are paying for the full subscription price that includes those apps - if you are not going to provide those apps, you need to change the pricing and/or offer a different tier subscription to Mac users.

                                        3 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…)
                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • What would be very cool would be if you could talk code ... say i want a form to do xyz and it pull details together... I'm not a programme

                                          i'm not a programmer and find it difficult and dont have time.. but have a lot of ideas which i want to get to work fast and when i speak with programmers they don't understand what i want etc so take a lot of hard work and time to make progress..

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

                                            We appreciate your suggestion, however feel it is not the right place for it.
                                            Access is a great tool for both developers and end-user with minimal programming/tech skills.
                                            Ramp up before you are able to create something meaningful is relatively short. Give it a try!

                                            Michal [MSFT]

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

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base