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. Add Save As... back to the Query context menu

    In earlier version of Access, when you modified a query the context menu had the choices of “Save”, “Save As…” and “Close” in the context menu. Since the ribbon was introduced, the context menu only provides “Save” and “Close”, if you’ve made a change in the query and don’t want to over write the existing one, you have to go to the File | Save Object As route to get to the “Save As..” dialog box.

    20 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  2. Form scaling and splitter bars

    Provide for splitter bars as well as form size scaling

    20 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. FULL OUTER JOIN

    The current workaround is to UNION a LEFT OUTER JOIN and a RIGHT OUTER JOIN together. This is repetitive and error-prone. Please implement the FULL OUTER JOIN in Access.

    20 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. SQL View - Add replace to edit mode

    If in SQL View of a query it is extremely annoying not to have the replace command handy.

    19 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Replace VBA with .NET Core then make cross platform and cloud

    This is a great RAD app, it should be available to all users on any OS. Please keep it relevant. I may turn ancient otherwise cause I'm gonna to keep using it for prototyping!

    Access is cool.

    Please don't die.

    19 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Runtime  ·  Flag idea as inappropriate…  ·  Admin →
  6. Please allow the storing of comments in the SQL of stored queries.

    If a query is at all complicated, it can be good to store comments, but this is not possible currently in Access.

    19 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Make it possible to stop Access Desktop from being an Automation Server so that security is improved

    Currently, if a user has Access running, much of what is meant to be secured can be accessed from another program, e.g. Excel, via Automation. This is not good.

    19 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Package accdr with the runtime

    Please make Access package the runtime with mde/accde/accdr into a standalone EXE like VFP and RBase to avoid the annoying setup and version conflict and make it a truly stand alone app.

    19 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Runtime  ·  Flag idea as inappropriate…  ·  Admin →
  9. 18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  10. Enhance Vertical Text to turn 90, 180, 270 degrees

    Idea here is, that you should be able to turn text a) not only top to bottom but also b) flipped and c) bottom to top

    18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Better Backwards Compatibility

    I have three version of MS Access - 2013, 2010 and 2007. I need this so if I develop a DB with library references (in particular the MS Excel library) and it has to work in an earlier version of Access (so if I developed it in 2013 but it has to work in 2010) I have to open it in 2010 and make sure the references are not missing before giving it to a user. I have tried multiple times to write code that will try and remove the missing reference and add a valid one but why? These…

    18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Async and await

    Async and await like .net.
    Access as an application that connects to remote data (sql server or web apis) and then freezes on every call makes no good user experience.

    18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  13. Add Calendar Objects

    table, form, report: all oriented to a calendar display. I imagine the table/date field can be optioned for single day, hourly, 1/2 hourly, 1/4 hourly.

    Not just appointments such as is served by Outlook; there is a steady demand to see data in a calendar display - orders, sales amounts, work processes.

    17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Add the ability to import selected VBA references in the Import Objects dialog

    A frequent task in Access is to import some or all database objects from an existing database into a blank new database. After that, we must painstakingly set all non-standard VBA references in the new database the same way as in the old one.
    It would be nice if we could specify in the Import Objects dialog which references should be copied from the existing database into the new one.

    17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  15. Edit MS Access db / vba code within Visual Studio / VS Code

    Edit Access db / vba code within Visual Studio / VS Code with the rich IDE features that this implies.

    17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  16. Improve the Colour Selection Feature

    To choose a font or background colour in Design View is really abit clunky to say the least. Say you select a control and want to change its colour...
    If you Right click on the control and select Back Colour you get a rather feeble array of 70 colours, some too dull and others too bright.

    If you go to the properties of the control you see a hex number and a drop down arrow and a triple dot, the dropdown giving you a range of system colours (but you can't see what they are) and the triple dot giving…

    17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Buy out EverythingAccess.com's vbWatchdog add-in and incorporate it into VBA

    Error-handling: Buy out EverythingAccess.com's vbWatchdog add-in and incorporate it into VBA. It makes error-handling so much easier and much like that in .NET.

    17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    13 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  18. file corruption. make access more robust. even with sql server backend is frontend corruption a problem

    I would think after all these years MS has a pretty good knowldge about reasons for file corruption. It is quite the joy when The dreaded dialog that deletes Your vba Project appears...

    17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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…

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. 16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base