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. Bug fix needed for MS Access Update queries with WHERE clause

    Bug fix needed urgently!

    11/12/19 Office ProPlus 365 Update broke Access UPDATE query with WHERE Clause.

    Queries without WHERE clause still work.

    Can be recreated in new mdb or accdb database with single table. Write a query that tries to Update a value in the table. If the query has a Where clause, the query fails with a message of:

     Query 'qryName' is corrupt
    

    The database is NOT corrupt. Moving the database to another machine that has not been updated with today's Update (16.0.11328.20468, depending on Channel type), allows the query to work.

    Query fails whether table is in the…

    186 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Done!  ·  51 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  2. please fix the jump occurring when scrolling in the navigation pane of Access 2016

    When scrolling in the navigation pane of Access 2016 on a Windows 10 box, the list always 'jumps" back up to a higher place than I have scrolled to. Though I have applied a few changes to my mouse and set screen enlargement to 100% (which is not realistic for me as the font is too small), the screen still jumps. I never had an issue in previous versions of Access. From researching a fix, It appears to be a long standing and unaddressed issue. It's a migraine trigger when the screen jumps and I'm trying to find something in…

    8 votes
    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 →

    Hi, this issue is fixed in Office 365. I am resolving this so that your votes will be returned to you. If you see any further issues, consider submitting feedback using the Help tab in the ribbon in Access (of course feel free to make suggestions here as well)

  3. Would like to hear ideas from the Access Team via Surveys

    We the Access developers and users have mostly provided good ideas in this forum, some which you have implemented, or are planning to.

    Likewise, I would also like to hear about any ideas the Access Team may have via a posted survey so we can provide feedback. Please be more proactive in collaborating with us, we will provide valuable input.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Product Marketing  ·  Flag idea as inappropriate…  ·  Admin →
  4. Access 2016: Form border width is too narrow .

    Sizeable MDI forms in Access 2016 have a single-pixel border that is very hard to grab with the mouse.

    The form borders show as a single-pixel whether the form mode is "no border", "dialog", "sizable" or "thin".

    One work-around is to make the form a popup form, but if you make every single form in the database popup, you lose the MDI functionality and the ability to have a genuine popup form. When everything is on top then effectively nothing is.

    This creates a serious accessibility issue particularly when combined with the fact that MS Access forms and controls don't…

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  5. Please fix the problem with embedded ole objects in Access Forms and Reports with Windows 10 ver 1703

    I recently updated my computer to Windows 10 version 1703 and since then embedded objects in Access forms and reports do not display properly (cannot be seen). When Windows is downgraded to its previous version the problem disappears. The problem occurs with Access 2010, Access 2013 and Access 2016 (all 64bit).

    To demonstrate the problem do the following:

    1) Create a blank Access Desktop Database (Database.accdb).

    2) Create a new table (Table1) within the database.

    3) Add an AutoNumber field (ID) to Table1

    4) Add an OLE Object Field (Document) to Table1.

    5) Create a blank form (Form1) within the…

    29 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Done!  ·  15 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Linked Table Manager: select all tables from same back end

    One of the biggest pains is when you have multiple back ends and Linked Table Manager (LTM) prompts you at every table. When you have lots of links and multiple back ends, it's a pain to go through and select all from only one back end.

    Idea #1: Click on a single table in LTM, then click a button: "Select all tables from same back end." Voila! Now you can update that single back end, and then move on to the next one.

    Idea #2: Sort the tables by back end. Not as convenient as Idea #1, but would still…

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

    A new and improved Linked Table Manager is available to O365 subscribers starting version 1808 (Build 10730.20088).

    Please continue to provide feedback and help us improve it further.

    Access Engineering

  7. Fix borders in Access 2016 to work properly!

    Borders on various MDI documents still do not work correctly on forms and datasheets for resizing with mouse (especially lower right corner). Difficult and unreliable to grab borders and border corners at all. Problem has been reported many times and is well documented on the net. Still unfixed as of 12/27/2017.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Done!  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Build a new better Access

    Imagine a client side, pure javascript, SPA web application that displays windowed, data bound forms that talk to SQL Server. These forms are modeled with all of the well though out capabilities of Access forms (same subforms, datasheets, subdatasheets, controls, events, and properties). The development environment is Access-like but Javascript has replaced VBA. SSRS and PowerBI render the reports. SQL Server is the database and the web server, delivering the application through a web port, manages the session/connections, and maintains data. The product comes with SQL Server. Not bound to the cloud, but bound to SQL Server.

    14 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Done!  ·  6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Please update Themes (add Dark Gray and Black) to be consistent with other Office suite

    We (Access folks) were promised the Dark Gray and Black themes over a year ago. All other Office apps have these. "Blinding white" and "(not my) Colorful" are not very good options, especially when we are trying to be consistent with other Office apps that have 4 choices. Thanks

    60 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    8 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Refresh table on right click

    Whenever I modify a table or a view in SQL server I need to go refresh the table link. Currently that means
    * right click a table
    * Select Linked table manager
    * Find the table I want to refresh
    * select it
    * click refresh table links

    I would really like it, if we could simple right click a linked table, and just select refresh to have that single table refreshed.

    30 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Done!  ·  6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Fix form border widths in Access 2016 under Windows 10

    I don't know if this is a general problem with Office 2016, or if it is specific to Windows 10 users, but I find that sizable MDI forms in Access 2016 have a single-pixel border that is very hard to grab with the mouse.

    The form borders show as a single-pixel red line, and have no difference in appearance regardless of the mode of the form, whether the mode is "no border", "dialog", "sizable" or "thin". The border appears the same in design mode.

    I've tried this on a couple of different computers running Office 2016 under Windows 10, and…

    247 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    94 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  12. Include Access runtime in editions of Office which have click-to-run which stops installation of most up-to-date version of runtime.

    When a PC has an edition of Office 365 installed which does not have the full edition of Access included, e.g. all the Business editions and the basic E1 enterprise edition, it is not possible to install the current version of the runtime as well since the Access runtime is an MSI installation and Office 365 is click-to-run. See https://blogs.office.com/2015/12/16/access-2016-runtime-is-now-available-for-download/ for more details.
    If Microsoft do any serious development on Access (let's call it Access 2019), it means we cannot install the Access 2019 runtime and will be stuck with the Access 2016 runtime (or earlier), thereby missing out on…

    19 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    14 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Make it easier to select edges of controls/boxes for re-sizing

    When selecting control edges such as in Query Design when re-sizing the table/query boxes, make it easier to select the edge. Right now, I need precision movements to get the mouse to select the edge to re-size the box. This applies to almost every instance of selecting a control or box within Access.

    75 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Done!  ·  29 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. DoCmd.OutputTo acOutputReport, , acFormatPDF..." crashes after 10 minutes (Access 2016)

    Create PDF in accdb is no problem.

    Create PDF in accde or accdr crashes after 10 minutes or sporadic
    only with Access 2016 (with 2007, 2010, 2013 everything is fine)

    30 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 →
  15. Drag Tabs to Rearrange

    When in tabbed View, it would be nice to be able to drag tabs to rearrange them

    thank you

    22 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Done!  ·  8 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Access Link Table Manager

    In the Link Table Manager, when users chooses "Select All" it should relink all tables at once rather than hitting "ok" button to confirm if that table should be relink.

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

    A new and improved Linked Table Manager is available to O365 subscribers starting version 1808 (Build 10730.20088).

    Please continue to provide feedback and help us improve it further.

    Access Engineering

  17. Do something before the Access Team looses it jobs

    Every single good idea that has been posted here has been rejected. It truly appears that MS is only interested in their cloud products.

    The Access Team better do something or they are all going to looking for a new job like the rest of us who rely on their product to help make a living.

    The past month has been filled with the rejection of ideas, some that could bring this product to new levels. Either it is too difficult for their developers or its all about $$ in the cloud services.

    It amazing they just cannot see that…

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

    Hello,

    Please follow what’s been added to Access 2016 (O365) here:
    https://support.office.com/en-us/article/what-s-new-in-access-2016-76454345-f85d-47af-ace1-98a456cb3496

    You can also view O365 public roadmap and search for new features that are in development
    https://products.office.com/en-US/business/office-365-roadmap

    Another good source of information is the Access TechCommunity space here:
    https://techcommunity.microsoft.com/t5/Access/ct-p/Access_Cat

    Regards,
    The Access Team

  18. Bug in Access 2016 Build 9126 - right-click fail

    With Build 9126, can no longer right-click on the title bar of open objects -- unless the database is set to "Tabbed Documents" in the Document Window Option. If it's set on "Overlapping Windows", then the right-click only works when on the object in the Navigation Pane.

    So if I design a Query and then view the Results of it, I have to Save the Query so I can access its Design View again.

    3 votes
    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 →
  19. I have an idea that will make (access) better .. how can I present my idea to someone at Microsoft .. jerrywa0h@sbcglobal.net

    I have an idea that will make (access) better.
    ? how can I present my idea to someone at Microsoft ?
    jerrywa0h@sbcglobal.net

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  20. fix broken link for contacts database intro

    fix broken link for contacts database intro

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

Access (Desktop Application)

Categories

Feedback and Knowledge Base