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. Fix Docmd.Transferspreadsheet

    Microsoft Access and Microsoft Excel you would think would be hand in hand... but the problem has persisted for years that it has always been problematic getting the correct data types between Access and Excel columns when Importing and Exporting to and from Access to Excel and vice versa.

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

    Excel doesn’t support data types which makes it very hard for Access to recognize data types from Excel when importing.
    When using the wizard to import data from Excel, you can determine the column types and save the steps – this could be a workaround to mitigate the issue.

    Access Team.

  2. Is Anyone Home?

    As a VBA developer who knows the language inside and out, I provided a ton of feedback about 5 years ago on a consensus of what was requested by developers at large. Microsoft does NOT listen. No need to reinvent the wheel here.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  3. Can we have the option when you run a runtime for the first time to remove the security warning

    If the Access Front End is not stored in My Documents, the only way to remove the warning is to poke around in the Registry and put in the path where the Front End is stored. This is dangerous and not user-friendly. Ask the user if he/she accepts the risk and then allow use without the warning.

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

    You pushed upon the Office community the Ribbon back in 2007, when are you going to finally give us a GUI tool to develop ribbons properly? Right now, the ribbon is a half-baked concept with no tool to develop with.

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

    At the moment there is no plan to develop a tool for creating ribbons.
    This suggestion should probably be directed to a broader UserVoice site as it relates to all Office products and not just Access.

    Thanks,
    Michal [MSFT]

  5. Fix Long standing known bugs!

    Instead of looking for new features, why not fix what doesn't work properly. There are a number of well documented bugs (15+ years old in some cases?!) it would be nice if they were addressed.

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

    Dolly (et al), the risks involved in fixing bugs (and introducing new ones or breaking existing solutions) is a major consideration for us when prioritizing the bugs we are attempting to fix.
    With that in mind, we are looking also into some of the older bugs and assessing the risk, investment and impact.

    It would be great and much more in line with the UserVoice site objective, to specify which bugs you are looking for us to solve, which are the major pain point for you.
    I suggest you list them as separate items in this site and let others vote on them.

    In order to free up your votes, I’m ‘closing’ this item as “no Current Plan”.

    Thanks

  6. Future of MS Access

    Hello
    My post is a general post about which way should MS Access take in the future. I have used Access as a professional tool in my company against large and small companies from the early versions of Access. I believe that this is the most common use of Access although Microsoft from the beginning of the product have added this at the Office package as a low-threshold entry to the database worlds. Microsoft has reduced the availability of Access in its Office suites from early beginnings. In view of this, I mean Microsoft should let go of Access as…

    19 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  7. Search and replace on all database objects.

    Queries, Forms, Reports, Macro, VBA, possibly even tables.

    Today I do this by exporting all database objects to text files, using a utility that I built, and then using a customer text search app that I built to find strings using regex matches. Then I have to go and open the objects and manually make the changes.

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

    Thank you for posting and supporting.

    We realize the ask is to have this as a native functionality in Access but there are great third party tools available to solve this problem, and currently there is no plan to enable this.

    Access Team

  8. Local Help

    Enable Local Help Files as it used to be. The web help is slow, often leads to incorrect correct.

    28 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  9. Include Access Desktop in all O365 subscription plans.

    The idea is to demonstrate its power for developing sophisticated applications and to proliferate its use. The average user tends to use Excel instead of Access because it's a lot easier for them to grasp, so perhaps MSFT can create a website for all Professional Access Developers and refer users who desire education and development assistance?

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

    Thanks Frank for the suggestion.
    I’ve passed this feedback including all comments) to relevant folks.
    Since it’s not a suggestion for the product per-se, I’m updating the status so you can get your votes back.
    Use them wisely :-)

  10. Enable multiple versions of Access to co-exist on the same machine.

    Enable multiple versions of Access to co-exist, side by side, on the same machine without ill effects.
    Just like there can be multiple versions of Visual Studio, SQL Server, etc. Currently, to work in different versions of Access we need to maintain a separate machine (physical or virtual) for each version of Access.

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

    Hi Alphonse,
    It is not clear what is the problem you are encountering. Going through the comments other Access users left here, didn’t help figure it out as well.
    To the best of my knowledge there shouldn’t be an issue with running multiple versions of Access on the same machine, so I’m closing this request.
    If you feel strongly about it and can provide more information, please create a new request.

    Thanks,
    Michal [MSFT]

  11. 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. Add Pivot Charts back to Access.

    The original Pivot tables and Pivot Charts in Access 2007 were very easy to use and a great benefit to builders and users. I am still using 2007 for that very reason, since I have many applications that rely on the pivot functionality and I am a great believer in graphical representation using Pivot Charts.

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

    Thanks everyone for voting and supporting this suggestion.
    As you are all aware, Pivot Charts and Pivot Tables have been removed from Access 2013 because the technology they relied on was deprecated (Office Web Components).

    Voting and commenting on this suggestion (and on this https://access.uservoice.com/forums/319956-access-desktop-application/suggestions/11510094-put-pivot-tables-back-into-access-surely-a-databa) has been very valuable to us to distill the requirements and needs.

    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]

  13. Give us a wizard to create ribbonbars like we used to have for the old menubar

    Give us a wizard to create ribbonbars like we used to have for the menubar. Creating complex ribbonbars by storing HTML in the USysRibbons table is very time consuming to create and maintain. Especially hard to debug errors.The old menubar wizards made this task quick and easy.

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

    At the moment there is no plan to develop a tool/wizard for creating ribbons.
    This suggestion should probably be directed to a broader UserVoice site as it relates to all Office products and not just Access.

    Thanks,
    Michal [MSFT]

  14. 6 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 →
  15. Provide a better SQL editor

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

    231 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    23 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. If you are not going to be fully committed to developing and improving Access- Make it Open Source

    A least bring in the top developers to have a serious discussion the Many issues with Access.

    16 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 →
  17. Please do a better job of marketing Access!

    Many O365 blurbs and Microsoft announcements do not mention Access Desktop or Web products, Several users even think that Access is no longer a part of MS-Office.

    Access Desktop's strength is its ability to work with a wide range of data and tight integration with other Office components. One of the negative perceptions is that it's only a desktop app, but hooked up to SQL Azure, or any other remote DB, and properly optimized for web traffic, it can be truly cloud enabled, while retaining the advantage of
    a rich desktop client that can interact with other Office components.

    Some…

    38 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 Frank for sharing your thoughts and suggestions around this important topic.
    I’ve noted the info and shared with relevant folks on the team.
    For now, I’ll update the status to “No Current Plan” just so you can all get your votes back.

    with that – if you feel that there are key ways to make Access more appealing (like enabling it to run on multiple platforms) – please create a new suggestions for them and let people vote on them.

    Thanks!

  18. Provide a way to develop a truly "stand-alone" app

    Hiding the ribbon, navigation pane, and database window, along with denying access to tables, queries and design environment always requires a lot of work. Would be nice to have a MDI form, and menu bar control. The user would only see and have access to the MDI and its menus. Everything else is hidden and unaccessible by the user.

    68 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    No Current Plan  ·  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  19. Publish A Developers Roadmap for MS-Access Desktop and Web.

    Give us some CONCRETE plans to hang our hats on for the future path MS-Access is intended to take. We need this sort of roadmap from Microsfot to help us PUSH BACK against the IT and other technologies trying their best to PUSH MS-Access OUT of the picture entirely!

    It would be REALLY GREAT to have MS's Mighty Marketing Management Machine actually step up to the plate and:
    1) understand this tool and where it fits into the overall IT/Business picture (something they plainly fail to comprehend now)
    2) Actually Market and support their own damned product! (when's the last…

    35 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 →

    We understand the need for a public roadmap, and thank you for calling it out again.

    I’m updating the status to No Current Plan so that all supporters can get their votes back and use them wisely :-)

    Thanks,
    Michal [MSFT]

  20. make Zooming and Printing improvements to the RELATIONSHIPS diagram window/view

    The Relationships Diagram window has been a static feature in need of serious improvements - like adding comments to the relationships, and descriptions to the tables in the diagram (like tooltips). The control of Zooming and Panning - and printing/Previewing the diagram could use some serious overhauling. The automatic pagination - and the lack of control of what parts of the diagram are clipped to other pages - is HORRIBLE. Given a sufficiently large entity model, the existing capability falls woefully short of helping us to diagram and document our databses decently! How about giving us Multiple Relationship Diagrams (Pages)…

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

    Thanks everyone for posting and supporting.

    We understand the need but currently there is no plan to improve zooming and printing of the relationship diagram.

    If you have additional related suggestions, please create new items for them.

    Thanks,
    The Access Team

  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base