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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Deprecate all versions of Access

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

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    No Current Plan  ·  7 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  2. Access 2016

    Access 2016 non è più presente il Wizard per la creazione di pacchetti da distribuire con le Runtime library, vi prego di rimetterlo al più presto perché era utilissimo.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks Roberto for posting.
    The wizarding package has been removed in Access 2013.
    As useful as it may have been to you and others, we know that most developers used third party custom installers (similar to Dolly’s suggestions below).

    Michal [MSFT]

  3. VBA Break or Cancel ability in debug mode

    In testing a vba fuction that is running badly or seemingly endlessly, I used to be able to press CTL+Break to stop it from running. In Access 10 this no longer works, I have to completely crash out of Access - which i hate to do with a huge db. There should be a way to cancel safely?

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  4. Access database plugin system

    Many of the ideas on here correctly identify that Access is a great database tool.
    However would have great value as a frontend to different databases, AZURE, MS Server, MySQL, PowerQuery direct integration.

    So create a plugin system to allow the user to change db's local or remote

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  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 (including Azure SQL and SQL) server 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.

  5. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for posting.
    We are well aware of the issue you mentioned, and we working hard to ensure high quality of Access and the rest of O365 products.

    Updating to No Current Plan to free people’s votes.

    Thanks,
    Michal [MSFT]

  6. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  7. Please can we have Access for IMac?

    Having moved to an iMac suddenly find this is not available so still needing to run my old slow pc/laptop

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Add Property Sheet contextual help

    For new users, the Property Sheet for most objects is loaded with options, most of which are optional. However, some are not optional depending on the user's intent...mostly to do with binding objects to other tables, etc. If Access were a bit "smarter" it may be able to determine what a user is trying to do and highlight the appropriate Properties required to be modified along with a brief explanation, or a link to RELEVANT help.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  10. ODBC drivers to handle more dates and bigint correctly.

    Momentarily you have for SQL Server 2 drivers the good one, which is idiotically depreciated and the slower ODBC one, which is "the future" If using the old one bigint, datetime2 datetimeoffset date and time are "TEXT" ODBC converts 2 more datetime2 and date but the rest still is "TEXT" - why ?

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  11. BUG: Find and Replace Access 2016 and 2010

    There appears to be a bug within Microsoft Access on at least 2016 and 2010 release versions.

    When doing a Find and Replace on a Field, the first record is acted upon twice in certain circumstances.

    When Highlighting the Entire Column or just one cell, the first cell of the field, or the one cell chosen gets acted upon twice by the find and replace after hitting Replace all.

    I can provide screen shots upon request, but you should be able to reproduce this easily using

    1
    21
    312

    and doing a find On 1 and replace with 1L

    you…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for reporting.
    We will add this bug report to our backlog and see that it is prioritized and handled.
    In the meantime, I’m updating the status for ‘No Current Plan’ so that you use your votes again.

    Thanks,
    Michal [MSFT]

  12. FIX BUG: runtime error when resizing subreports in a report using VBA

    If you have a report that needs to resize a subform control containing a subreport for each record, you'd like to change the subforms width and height properties in Format event procedure. In preview this leads to a runtime error "not enough system resources".

    Changing the size in Load event procedure works properly. But you can't have indivual sizes for each record.

    I encountered this issue in Access 2010.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for reporting.
    We will add this bug report to our backlog and see that it is prioritized and handled.
    In the meantime, I’m updating the status for ‘No Current Plan’ so that you use your votes again.

    Thanks,
    Michal [MSFT]

  13. Create a way to see other users accessing the same object.

    If there was a way to see other users on the same object it would make it so much easier. The risk for deleting data would be gone.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    No Current Plan  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    No Current Plan  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Fix Bug - Random Crashes - Exception Code: 0xc0000409

    I'm getting random crashes using MS Access, below is the event viewer log

    Faulting application name: MSACCESS.EXE, version: 16.0.7766.2060, time stamp: 0x58a90c80
    Faulting module name: mso40uiwin32client.dll, version: 0.0.0.0, time stamp: 0x58a821f1
    Exception code: 0xc0000409
    Fault offset: 0x000000000046d3cc
    Faulting process id: 0x433c
    Faulting application start time: 0x01d29f7652c05e88
    Faulting application path: C:\Program Files\Microsoft Office\Root\Office16\MSACCESS.EXE
    Faulting module path: C:\Program Files\Common Files\Microsoft Shared\Office16\mso40uiwin32client.dll
    Report Id: ba2d73b2-fda6-4c54-826e-a067b517c502
    Faulting package full name:
    Faulting package-relative application ID:

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →

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

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

    Thanks,
    Michal [MSFT]

  17. Make an Access Lite version free

    One of the main reasons Access doesn't have the traction of other stacks and development environments is because it's competitors in the various spaces are free. MySQL, MSSQL, PostgreSQL, .NET, PHP, Ruby... etc. Access continues to lose it's market share because it's entry level is too high. Making an Access Lite version which allows people to make basic forms, basic reports, basic tables, and basic code behind would improve Access's standing to perhaps a 2nd class citizen in the development ecosystem. Right now it's a 3rd class citizen that is made fun of by all the other "real developers" and…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for your suggestion.
    It is mostly relevant to Office/Microsoft business planning and I’ll forward the input to the right people.
    I’m updating the status to No Current Plan as addressing this request is not really within the realms of the product team.

    Thanks,
    Michal [MSFT]

  18. Design Access to create front ends to use on Android

    Android is the world leading mobile platform yet Access cannot create front ends which could be used on say mobile phones or tablets and connect to a central database back end on a local network. This means that Small to Medium Enterprises are moving away from windows and Access and emplyoying specialists to create Apps for their mobile devices and use MySQL for the back ends.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  20. adp

    Who knows why Micrososft cut adp file format? They afraid something? Why they kill adp idea, Very Pity...

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base