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. accde should also remove the ablity to modify tables and queries

    When one creates an accde database, Ms access 2007 SP3 up to 2016 should also remove the ability to modify tables and queries.

    34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Local Data  ·  Flag idea as inappropriate…  ·  Admin →
  2. There should be a feature to disable the ability to export all objects in access desktop database

    There should be a feature to disable the ability to export all objects in access 2007 SP3 up to access 2016 desktop database, regardless whether the database is passworded or not.

    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  ·  Local Data  ·  Flag idea as inappropriate…  ·  Admin →
  3. Disabled default "Name AutoCorrect Options"

    And/or make it a permantent setting for all new databases after an user has change these settings

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
  4. 2 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  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  5. VBA Application Add-Ins

    Create a new type of VBA add-in (*.accda) that loads before the database is loaded, can display its own ribbon and is unloaded after the database is unloaded. This would enable VBA programmers to build application add-ins like in Excel or Word.

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  6. Improve the statistical capability of MS Access

    Take on IBM SPSS Modeler. For example, work with the developers of R Statistical Computing to provide regression, clustering and neural network functions. At the very least extend the Domain Aggregate functionality to include a percentile capability.

    7 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 →
  7. Sort by object name in the Expression builder - Expression categories

    When we use the expression builder, the middle column (expression categories) currently does not sort alphabetically so it makes it time consuming to search for controls.

    4 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  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  8. with accde: create forms and controls at runtime. even reports.

    how wonderful it would be to have programmatic access to create forms and Controls at runtime (compiled version)
    Even The ability to create and change reports.

    22 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. 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 →
  10. Macroes vs VBA in Button Wizard

    When using the Button wizard MS Access creates macroes as default. This should be an option if you prefeer macroes or vb as the event code.

    25 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    10 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  11. improve ACE / eliminate or expand limitations

    Too many queries fail for obscure reasons. E.g., a crosstab that has a subquery somewhere in it. I bet there are already open defect on a lot of these issues from the JET days. Work them! Limitations like the 32 table limitation occasionally get in the way as well.

    (Again hating to spend votes on defects, but it is what it is.)

    4 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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  12. bring it into conformance with high DPI design standards

    Need to clean up all the UI to scale properly on high DPI displays. E.g., Navigation pane vertical object spacing, low res navigation pane object and navigation (expand/contract) icons, and "Save changes to the following objects" dialog box.

    (Hate to spend precious votes on what is basically a set of defects, but there it is.)

    65 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Planned  ·  5 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  13. Support strong-typed nullable data types.

    In VBA, we can only store nulls in a Variant data type. But I hate this because this lacks information whether this is a string, a number or date. In SQL, those data types are all nullable but we have to constantly do Nz(), IsNull(), to avoid the nefarious error "Invalid use of Null".

    Please make it possible for us to specify a nullable data type so that we also know this can be only either a null or a number (and thus prevent invalid entries of string in addition to writing self-documenting code).

    12 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  14. Why is it so hard to get at database Objects' metadata?

    These items are VERY useful when we are asked to go fix a previous coder/employee who may or may not be with us any more. Elsewhere in this forum others have suggested adding Notes field with date/time stamps for each object. I endorse that.

    Would be really sweet if there was a quick way to get to items like the Description field in a Table definition, the existing Description field for objects (right click on object in Database or F11 window). I note that a right click is pretty quick, but this means you can only see one object at…

    2 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 →
  15. Column Order in Queries

    Is it really necessary to re-arrange the column order when I save a query? It tells me MS Access is reducing the QBE grid entries into SQL, optimizing that syntax and when asked for it later the presentation looks scrambled. While this may be needed internally, how much harder can it be to ask the internals to remember the column order?

    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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  16. Global practice of changing defaults to New and "Improved" features

    Microsoft has this extremely annoying practice of changing a feature and making it the new default. For example I personally do NOT like tabbed documents. I recognize other people like it. Who decides the tabbed document protocol is "better" (it is not!) and very annoyingly making it the default. This is just one example. Many others should come to mind.

    Please understand some of us have been using Access for a very long time. When I open a new version, my first pulse pounding moments are filled with, "Oh God! What has the Access team "improved" now? Until I find…

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Dialog Box Sizes

    Do NOT have ANY dialog boxes that are limited in size, esp. when they open modally (do not let you click outside their zone of control).
    Linked Table Manager is one. Library File management dialog box is another (where we go to tell it where a new or missing dll file is located). There are others. Simply stop using this very old protocol.

    3 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 →
  18. Report View: Hide empty subreport

    In print preview and normal view, if a supreport is empty, it gets hidden. Please do the same for Report view.

    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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  19. Drag a datasheet to Excel

    Instead of manual ctl-A, Ctl-c, open excel, new worksheet, ctl-v.

    2 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  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  20. 7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

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

Access (Desktop Application)

Categories

Feedback and Knowledge Base