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.

  1. 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!

    413 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…)
    • Linked Table Manager: select all tables from same back end

      One of the biggest pains is when you have multiple back ends and Linked Table Manager (LTM) prompts you at every table. When you have lots of links and multiple back ends, it's a pain to go through and select all from only one back end.

      Idea #1: Click on a single table in LTM, then click a button: "Select all tables from same back end." Voila! Now you can update that single back end, and then move on to the next one.

      Idea #2: Sort the tables by back end. Not as convenient as Idea #1, but would still…

      14 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…)
      • Filemaker is a subsidiary of Apple Inc. Access databases have more users. Could Access product become a subsidiary, not just part of O365

        Filemaker is a subsidiary of Apple Inc. Access databases have more users. I have been using Access databases for the last 15 years. Could Access database product become an independent subsidiary of Microsoft Inc., not just part of Office 365? Hate to see this product die.

        0 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…)
        • 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.

          48 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…)
          • Allow CTRL+A to select all text in a query's SQL View

            Pressing CTRL+A should select all text in a query's SQL View. It does not work in Access 2013.

            My current work-around is an AutoHotkey script.

            13 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…)
              Planned  ·  2 comments  ·  Admin →
            • Export Multiple Tables to Excel Workbook

              I would like the ability to export multiple tables/queries/etc.. to a single Excel Workbook. Currently, I can only export one table to a single workbook at a time. There are situations where I use Access to crunch some serious data in multiple tables and would like to be able to export all of them into a single workbook. As it stands, I have to export each one individually, then use the Excel Move command for the worksheets to combine them all to one workbook.

              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…)
                1 comment  ·  Admin →
              • Give us a new dll - MSJSON.dll

                Currently to work with XML objects from API calls we have an object model from referencing MSXML6.dll that make iterating through the response easy. With JSON we can only get strings of data that we have interpret. If you created MSJSON.dll for us we could manipulate JSON data as easily as XML and make life easier for developers dealing with API calls.

                20 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…)
                • ssma Version 7.4 32bit is missing

                  https://www.linkedin.com/groups/4843954/4843954-6276155203788111875?midToken=AQGyeGDcKwVRAw&trk=eml-b2_anet_digest_of_digests-hero-12-view~discussion&trkEmail=eml-
                  Either give us a 7.4 32-bit Version of ssma - no discontinue - or make an automatic updater for all 32-bit externsal declares. See discussion in LinkedIn

                  b2_anet_digest_of_digests-hero-12-view~discussion-null-e0fqv~j3ij3zf0~ay-null-communities~group~discussion&lipi=urn%3Ali%3Apage%3Aemail_b2_anet_digest_of_digests%3B5XMuHrjQS5%2Bpv8MBbhzupg%3D%3D

                  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…)
                    1 comment  ·  Admin →
                  • Continue and extend backend functionality from AWA in Access Desktop

                    Given the fact a decision on AWA has been taken, here's I think what the development team should do. 1. Make AWA datamacros available in Access Desktop 2. Extend with support of Update/Create/Delete Queries in the query designer. 3. Explode functionality by making datamacros that return just one value available as functions within expression builders of queries and datamaros 4. Support the database qualifier in front of tablenames the way it is already available in SQL-Server between databases. this way users can integrate AWA managed and non-AWA managed very easily. (integration with CLR SQL-server projects and other tools that generate…

                    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…)
                    • Change Link Path Without DB

                      It would be great to be able to Change the Path of existing Linked Tables to another path even if we don't have that path. This would greatly simplify deploying to client networks. We could deliver the database all ready and configured.

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

                        Thanks Dolly for posting.
                        Are you referring to runtime mode only?
                        If you could design this feature – how would you go about doing that? (this will help us better understand what’s the scenario in mind)

                        Thanks,
                        Michal [MSFT]

                      • Query designer: fix 'Unique Records' property when Images or memo filelds are included

                        In past versions of Access I have often built queries using the 'Unique Records' property, now in Access 2016 I find that the property is not available if the query includes memo fields or Image/OLE object. In legacy dbs, queries with images or memo fields using this property fail (returning multiple unique records).

                        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…)
                        • Add format properties for check boxes, option buttons.

                          Would be great to be able to adjust the size, border style, color etc. for the check box and option button controls! The properties box actually has the properties listed, but changing has no effect. I've always hated how small and boring these are on forms. Seems it would be a simple enhancement.

                          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…)
                          • Please fix the problem with embedded ole objects in Access Forms and Reports with Windows 10 ver 1703

                            I recently updated my computer to Windows 10 version 1703 and since then embedded objects in Access forms and reports do not display properly (cannot be seen). When Windows is downgraded to its previous version the problem disappears. The problem occurs with Access 2010, Access 2013 and Access 2016 (all 64bit).

                            To demonstrate the problem do the following:

                            1) Create a blank Access Desktop Database (Database.accdb).

                            2) Create a new table (Table1) within the database.

                            3) Add an AutoNumber field (ID) to Table1

                            4) Add an OLE Object Field (Document) to Table1.

                            5) Create a blank form (Form1) within the…

                            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…)
                            • Create a table / linked table with a size greater than 255 fields

                              When connecting to a commercial database such as Oracle, it may be trouble if all the columns of the table are not displayed.

                              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…)
                              • System Resource Exceeded, On Big Table

                                Can not allways count rows, update fields (ADODB/DAO),
                                SUCCESS RATE ................ONLY 40-80%...!!!!
                                BUG, Confirmed by :.......... Deepak Panchal10 - 9,745Points
                                Microsoft Office for Developers.Access for Developers

                                https://social.msdn.microsoft.com/Forums/office/en-US/6d973b12-b6e7-4386-8a59-0528645e570a/system-resource-exceeded-on-big-table-825942-rows-2147467259-access-2013?forum=accessdev#0c68222d-28cd-4115-bb46-ac63f81eecbc

                                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…)
                                • Document breaking changes

                                  The release notes for every new release of Microsoft Access should contain a complete list of all "breaking changes", i.e., changes that could cause an application which worked fine in Access Version X to break in Access Version Y.

                                  Documenting breaking changes is considered "best practice" when releasing libraries or development tools, and since MS Access is used as a development tool, it should adopt this practice.

                                  (See https://social.msdn.microsoft.com/Forums/office/en-US/d694e779-1b5b-4c50-b6e0-b4f488a46425/error-number-changed-between-access-2013-and-access-2016?forum=accessdev for an example of a breaking change which has not been documented.)

                                  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…)
                                  • Keep error numbers consistent across versions

                                    Apparently, error numbers for the same error change between Access versions. (See https://social.msdn.microsoft.com/Forums/office/en-US/d694e779-1b5b-4c50-b6e0-b4f488a46425/error-number-changed-between-access-2013-and-access-2016?forum=accessdev for an example.) This breaks existing code. Please keep error numbers consistent across versions.

                                    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…)
                                    • Document run-time errors

                                      Some VBA/Office library methods throw errors.

                                      For example, Application.LoadCustomUI throws error 32609 (Access 2007-2013) or 326010 (Access 2016) when the ribbon has already been loaded. Forms.Item throws error 2450 when there is currently no open form with this name. The "/" operator throws error 11 when a division by zero is attempted.

                                      These error codes should be documented with the method that can throw the error. For an example of how this could be done, have a look at the documentation of the .NET Base Class Library: The documentation of every method has a section "Exceptions", listing all exceptions that…

                                      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…)
                                      • Fix bug in Sort Order "General": Treatment of german umlaut "ü" is different from other umlauts "ä", "ö"

                                        In Access 2016, I have a database with Access File Format 2007-2016 and Database Sort Order "General".
                                        I have the following data in a table with Short Text field "TestColl"

                                        TestColl
                                        --------
                                        Aehnlich
                                        Ähnlich
                                        Baer
                                        Bär
                                        Froehlich
                                        Fröhlich
                                        Fruehling
                                        Frühling
                                        Oesterreich
                                        Österreich
                                        Ueberhaupt
                                        Überhaupt

                                        These are 12 rows. Now I run a Select Distinct query on this field. This results in only 10 rows:

                                        TestColl
                                        --------
                                        Aehnlich
                                        Ähnlich
                                        Baer
                                        Bär
                                        Froehlich
                                        Fröhlich
                                        Frühling
                                        Oesterreich
                                        Österreich
                                        Überhaupt

                                        Access has identified "Fruehling" with "Frühling" and "Ueberhaupt" with "Überhaupt", but it did not do this with the other umlauts "ä" and "ö".

                                        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…)
                                        • Improve Access Accessibility

                                          Improve accessibility for Microsoft Access when using Jaws and or NVDA screen reading software. I here that better support has been made for narrator, but until narrator becomes more usable for every day tasks, most people will use jaws or NVDA.

                                          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…)
                                          ← Previous 1 3 4 5 26 27
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base