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. Enable Access to work with Azure Multi-Factor Authentication

    There seems to be no way of allowing Access to link to an Azure SQL database where Azure Active Directory Multi-Factor Authentication has been enabled. This means that if an IT department switches on MFA Access can't connect to an Azure SQL database it can connect to where MFA has not been activated.

    If I have missed something, please tell me!

    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…)
      2 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
    • Create a new Comprehensive Windows Installer for Access Applications.

      Access needs a quick way to get a good solid installation of Back-end and Front-end databases including a registry edit for Trusted locations and versioning.
      It should also include the ability to:
      Add Icons,
      Add Desktop and other shortcuts,
      Allow user to accept an ELUA (End User License Agreement)
      Run simple scripts,
      Install with full windows trust. (maybe with a certificate?)
      An uninstaller.
      A check for updates function.
      Install support files into specified folders.
      Read simple system values and react accordingly (eg if 64bit systems then install 64 bit ODBC Driver)

      Also it would be nice if it could notify…

      83 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  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
      • Enable Access (and all VBA apps) to work with the new Microsoft Graph

        "Microsoft Graph is the gateway to data and intelligence in Microsoft 365. Microsoft Graph provides a unified programmability model that you can use to take advantage of the tremendous amount of data in Office 365, Enterprise Mobility + Security, and Windows 10.
        You can use the Microsoft Graph API to build apps for organizations and consumers that interact with the data of millions of users. With Microsoft Graph, you can connect to a wealth of resources, relationships, and intelligence, all through a single endpoint: https://graph.microsoft.com."

        It seems that just about every language except VBA can be used to run…

        24 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  ·  Cloud  ·  Flag idea as inappropriate…  ·  Admin →

          A new data connector that allows users to link to and import from Graph API is on our roadmap and will be released to O365 customers in the next few months.

          Stay tuned!

        • get more things to do on the website

          their should be more improvement on the app

          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  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
          • Upgrade Access SQL dialect to current ANSI standards

            MS Access's ACE SQL engine continues to run with a variant form of ANSI-89 with some ANSI-92 features while the rest of the relational database world has adopted more recent ANSI standards and at the very least fully comply to the universal, lowest common denominator standard accepted in the industry: ANSI-1992.

            Being a highly used, worldwide database for small to medium-sized shops and its popularity with the Office suite, enhancing Access's dialect to industry standards will add value to current and future users including the Microsoft brand. Even SQLite, a similar, very popular file-level database as open-source counterpart to 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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
            • Stop taking over .mat files. *I didn't even instal Access*

              .mat files are used by many apps, two of which I use almost daily - Unity3D and VRay in 3ds Max. Somehow they get along. Maybe because they don't try some bargie file extension takeover tactic. Wasn't there a time when this was in poor taste? OK .mov I get it, very rarely is anything else going to use that file extension. Go ahead, Quicktime. But Microsoft - .mat? Seriously? And not just the "open with", but the nature of the file(now a shortcut)?

              Some time in the last 24 hours, I'm guessing, Office and/or Windows applied some sort of…

              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  ·  Local Data  ·  Flag idea as inappropriate…  ·  Admin →
              • Bug using TransferDatabase

                Simple Form with Key Preview=YES. Write code so that when ESC key is pressed the app quits. Add a button to the Form. When button is clicked link an external table using TransferDatabase and then delete the table. Now the ESC does not work anymore.

                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 →
                • Autocomplete for calculated access form controls

                  When in form design mode. It's really time consuming write calculated fields. It would be great to have autocomplete formula like for built in access functions and database objects directly inside edited control.

                  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 →
                  • Select Navigation control Tab programmatically

                    Hi Team,

                    Currently we use this command to switch to a tab in a
                    NavigationControl

                    DoCmd.BrowseTo acBrowseToForm, TabToOpen, Me.name & ".NavigationSubform"

                    This works fine if there is a unique NavigationTargetName for the selected Tab/Button. If we have two or more Tabs with the same target form name, we are unable to open a specific Tab. The first tab with the matching targetName is opened.

                    I.e. TabA and TabC has the same targetFormName X
                    if we use the following command

                    DoCmd.BrowseTo acBrowseToForm, X, Me.name & ".NavigationSubform"

                    TabA is activated.

                    Problem: How do we activate TabC?

                    Regarding why we have same targetFormName:…

                    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 →
                    • add ETL-features to ACCESS (retry of: Add PowerQuery to ACCESS)

                      I still do thoroughly hope, you will integrate ETL-features to Access!
                      In EXCEL as well as in PowerBI you can use "retrieve and transform data" to collect data from diffent sources.
                      I don't want to write back data to the sources.
                      Many of my clients - financial controllers and data analysts - use ACCESS as a kind of datamart for their reporting, as I wrote in my BLOG "controllingexcellent". They collect data from different source, mostly TXT-files, CSV, Web, EXCEL-Files and Databases at the same time.
                      It is the "single source of truth" where data is stored. Many other reports…

                      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…)
                        0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
                      • Develop the SQL User Interface

                        SQL is something that I find particularly useful when I am running a database. However, the SQL user interface is very poor in my opinion. It should be more something like the Visual Basic interface, where when you start typing in a formula, then it has a dropdown with all your options and when you select the function from the dropdown, it will show you how to build the formula. For me it becomes very time consuming to have to go online to figure out how the function is built. Also it would be great if it can be colour…

                        19 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 →
                        • Putting a softkey in access to convert form to report

                          Its good to have a softkey in access to convert ( form) to (report ) so we don't have to design a report that have same shape and design aspect.

                          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…)
                            1 comment  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                          • Fix Access object executing

                            While MS Access is executing code during the object's event, all other events of the object are locked, so they will not be fired.

                            Let's say we have the Microsoft Calendar Control 8.0 ( mscal.ocx ) placed to a form and we have the code:
                            Private Sub Calendar1_Click()
                            Calendar1.Month = 1 + (Calendar1.Month) Mod 12
                            End Sub

                            Private Sub Calendar1_NewMonth()
                            MsgBox "Calendar1_NewMonth event" & Calendar1.Month
                            End Sub

                            The sample should displays a message box when the user clicks the control. In MS Access, the message box never occurs, as the NewMonth event is called during the Click event. If the…

                            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 →
                            • New Access Event

                              Dear Access Team,
                              The immediate need for a Before_AccessCrash(Cancel As Integer) Event is required.

                              The Cancel parameter is vital and must be included.

                              Kind Regards

                              The Team at ProcessIT

                              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 change report font when forecolor is set to automatic (black)

                                Cannot change report font when forecolor is set to automatic (black), because after changing the font and saving the report in design view, changes won't save and the font will default back to Arial.

                                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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                                • 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 →
                                  • Make the 'Compact and Repair Database' function automatic on saves

                                    Access file sizes grow rapidly, even if there's no database in use. PC's are fast enough to do the Compact and Repair function with very little delay in saving files. At least make it an option in the Current Database settings.

                                    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…)
                                      2 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Add an option to disable the 'Show Table' dialog when creating a new query

                                      It would be useful to be able to suppress the automatic display of the modal 'Show Table' dialog every time a new query is created.

                                      Currently I instinctively hit 'Esc' when creating a new query, knowing that this dialog will be displayed.

                                      I prefer to add tables/queries to my query by dragging them from the navigation bar.

                                      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…)
                                        1 comment  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Prevent tables & queries being copied in ACCDE files

                                        ACCDE files provide significant security especially if combined with password protection, disabling shift bypass, hiding navigation pane/ribbon/application window, using a SQL Server backend etc.
                                        Doing so prevents users importing forms/reports & of course code from another database. However, a major weakness & common complaint is that users can still import all tables & queries including hidden & system tables.
                                        It is possible to make tables 'deep hidden' to prevent this ...but even that can be reversed ...if you know how.
                                        Please add code to prevent this security loophole using VBA (not in the ribbon!). If users lock themselves out by…

                                        13 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 →
                                        • Option to attach any big file such as pdf along with personal image/photo place

                                          It will be great if there will be option to attach any big file such as pdf along with personal image/photo place

                                          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 →
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base