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. Provide a better SQL editor

    Please provide a better SQL editor with syntax highlighting, indention, IntelliSense and using SQL comments in Access 2017.

    233 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    24 comments  ·  Flag idea as inappropriate…  ·  Admin →

    The Access team is adjusting our status for this request – we are planning to embed the Monaco Editor (support for SQL Editor improvements) into Access, to be released within the next semester (first half of 2021), which will provide capabilities such as syntax highlighting, IntelliSense, SQL comments, and more. We are excited to have this capability released by next year, and we appreciate the energy and enthusiasm on this feature request. We still have a long ways to go to improve our experience with SQL, so please stay tuned as we execute on this objective!

    Thanks,
    Ebo [MSFT[

  2. Bring back the shortcut menu interface for creating shortcut menus

    Shortcut menus are very usefull and after access 2003 the interface for creating them has removed.You have to bring it back.

    27 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 →
  3. Permit Access handle MultiCore PC

    Permit (from VBA?) to instruct a program to run in a specific Core; so if we have a 4core PC, we can run concurrently 4 programs.

    2 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 →
  4. Need a better SQL code Query debugger

    When complex SQL code in queries fails because of invalid syntax, you are not allowed to switch to design view mode to more easily spot the error- you must fix the error first.

    A more robust error checker and formatter would be a big time saver.

    6 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 →
  5. Increase the number of table references from 2048

    With comprehensive applications, it isn't hard to get the dreaded "Can't open any more databases" error message.

    When this message is encountered, bad things happen internally and the database should be restarted.

    If this isn't possible, at least give us a handle so we can determine the number the system currently thinks exist.

    32 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 →
  6. Easier way to backup data

    Please add a standard way to backup your tables to an external database ( file or SQL) on time or in the case of a certian event.

    9 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 →
  7. DSN less connection wizard

    Please design a wizard for dns-less coonections to SQL databases. Make it easier to use Access as frontend devolpment for different situations.
    Other RAD tools have this already.

    11 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 →
  8. Join desktop and web database into a single solution that renders HTML5 user interface

    When database is created it should be possible to use it as a desktop database or to publish it onto for example IIS for a web usage without any changes to it. The publishing engine should be capable of rendering forms as a HTML5 user interface. VBA functionality should be interpreted as server side and or client side VB Script. Probaly forms should be saved as XML for that purpose.

    16 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 →
  9. 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 →
  10. Code Window in Form Design

    Instead of separate window where coding takes place outside of form design, have it as a window positionable beside or below the form design.

    1 vote
    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. MouseOver Highlighting on controls and continuous forms

    Should be able to have a property for controls that can highlight when mouse passes over other than a button. Similar to Windows 10 Start menu or other Windows menus. This should also be allowed for a single row on a continuous form. Perhaps this could be a property in conditional formatting.

    6 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 →
  12. Multiple Positioned SubForms with Sizers

    Allow a form to be MDI(or similar) so that you could place multiple subforms in a single form with framing, positioning and resizing… like Outlook

    9 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 →
  13. Improved Table Manager

    Create an enhanced table manager that allows users to specify data source (sql, access, txt etc), source table name, attached name, any passwords (encrypted or hidden) and primary keys so that the system will drop existing links and refresh as needed. You would need a couple of tables for data sources and data source tables but many developers have done this over the years and lots of examples that could be incorporated. This is used all the time.

    2 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 →
  14. Cache all query results locally while in Design view for forms/reports to improve performance.

    Sometimes queries can be expensive, or have errors affecting performance. Currently, if one of these expensive (i.e. very slow) queries is in a form's or control's Data source, (like a Combo Box, for example), that query can be re-evaluate repeatedly and frequently (very slowly EACH TIME) making any effort to edit or design the form a legitimate pain in the keester. Give us the option to cache these query results during development (Design View) so we can work FAST, like Access is supposed to!

    2 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 →
  15. 3 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. Touch screen compatible lists, scroll bars, etc.

    A lot of my clients want to be able to use Access forms on a tablet or touch screen. The controls really need updated to be compatible with touch!!! The worst offenders are scroll bars with list boxes and combo boxes close behind.

    136 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 →
  17. Make SQL and QBE Smarter


    1. When a query that selects identifiable rows joins to a query that aggregates data, allow rows in the identifiable part to be updated rather than making the query non-updateable. Extend this to heterogeneous joins so if one table in the join is updateable but another is not, allow updates to the updateable one.

    2. Stop smothering expressions with excessive numbers of parentheses. There is no reason that I can think of that would require an individual column name to be enclosed all by itself in parentheses.

    3. Stop reformatting MY SQL strings. I have a work-around for this but it is iffy.…
    32 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Provide an easier method to return or pass property values to a dialog form

    I understand this would require a re-wickering of Access forms, but this is difficult to accomplish in Access without some serious workarounds. At least have something like a Dialogresult property as in .Net so the user can get simple values from the dialog form when closed.

    0 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 →
  19. add Align Objects Center and Align Objects Middle

    These buttons would work they way they do in other Office products.

    Also, rename Align Left|Right|Top|Bottom for objects to include the word object. Align Left, for instance, is the tooltip for 2 very different things.

    1 vote
    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 →
  20. Open Query in SQL View

    Please give us the ability to open a query in SQL view directly.

    Also, when designing a query, don't process the records until we go to Datasheet View.

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

Access (Desktop Application)

Categories

Feedback and Knowledge Base