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…

    183 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    49 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  2. Cambiar la altura de la fila de encabezado en un hoja de datos

    La idea es poder manipular la altura de la fila de encabezado de una hoja de datos para poder darle un alto suficiente capaz de mostrar todo el título de la columna, pero sin cambiar su anchura.

    19 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 →
  3. Release an Office 2019 Access Runtime

    The Access Team previously stated that "Access is included in all Office 365 plans and Access 2016 Runtime click-to-run is also available for customers".
    This leaves a gap for anyone that has installed a lower version of Office 2019 that does not include Access. The Access 2016 runtime will not install as it is MSI, the Office 365 access runtime will not install as it clashes with Office 2019, which it insists you uninstall.
    We are having to tell our customers to not install Office 2019.
    So please can we have a runtime that plays nicely with Office 2019

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

    The current plan is to make Access RT 2019 available for customers to install from the Office Deployment Tool. This should be available in the second half of 2019.
    The recommendation for Office 2019 perpetual consumers, is (and will remain) to install the free version of O365 Access Runtime from the download page.

  4. Query is Corrupt bug has crippled five production applications.

    Query is Corrupt bug has crippled five production applications. How are we suppossed to wait nearly a month for a fix. This is insane. How can this be acceptable. Such a serious bug should be addressed immediately.

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

    See support.office.com/en-us/article/access-err..

    For updates, this is fixed for almost all channels now (a fix has been available for most users since 11/18).

  5. Someone needs to be fired (really)

    The recent Access updates that broke the most simple update queries was bad. However, Microsoft's response was even worse. Rather than Microsoft fixing the very serious problem they created, they said we should change the way we update records in our applications. What moron thought that was an appropriate response? Like many other throughout the world, we have a production system with 400K lines of code and you want us to rewrite every update statement because you do not want to roll out a bug fix? Then, someone thought it was a good idea to wait 30 days to fix…

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  6. make set_spapprole work in a VBA context

    SQL Server (see https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-setapprole-transact-sql?view=sql-server-2017) has a great security feature to allow an app to assume a security role when connected to the server. This doesn't work from Access VBA. This leaves us having to give permissions to data that users can subvert. Whilst this can be mitigated, if Access could connect using a user account with no permissions, and switch to an app role with the right permissions security would be wonderful. SetAppRole is particular pleasant in that in the context we still know the original user who started the app.

    21 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  7. State of the Art Replacement for Active X MS Calendar

    Everything revolves around time and Microsoft Active X Calendar is(was?) the perfect tool to use in a lot of applications we've prepared over the years. This gem works seamlessly even in continuous forms while current datepickers associated with textboxes won't do and subforms won't do and equally seamlessly integrates with VBA code and queries and control sources SQL. It doesn't work in Access 64 bit so it's about time to come up with a state-of-the-art replacement but even simply enabling it for 64 bit would suffice.

    19 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 →
  8. Problem "Error 3040 Query is corrupt"

    Problem "Error 3040 Query is corrupt" request for fix earlier than December 10. This bug causes a lot of problems for my customers!

    This problem should not be underestimated and is huge.

    KB4484127, KB4484119 en KB4484113

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

    See support.office.com/en-us/article/access-err..

    For updates, this is fixed for almost all channels now (a fix has been available for most users since 11/18).

  9. All the 32 bit dll and ocx should work in 64 bit os and office

    We are working with 32-bit add-ins for access. But it is not possible to work in 64 bit system which I am using.

    23 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  10. SIMPLE TRAINING QUESTIONS

    I CANT FIND ANYONE TO HELP ME WITH A SIMPLE QUESTION ON USING ACCESS. VERY FRUSTRATING. YOUR TRAINING M ODULES ARE OF NO HELP. I CALLED MICROSOFT AND NO ONE COULD HELP ME.

    1 vote
    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 →
  11. Horizontal Data in For

    We need the ability or a control to represent our data horizontally instead of vertically. Such as the websites they are representing their products horizontally and the customer can scroll. it would be a great thing if we have this ability in ms access.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  12. BugFix: Combo Datatype bug

    Please fix the combo box RowSource datatype binding bug.

    The bug is as follows:
    1. Create a table [Table1] with two columns:
    - [NumberField], datatype: Number, Double
    - [TextField], datatype: Short Text

    Add 1 Row to the table:
    [NumberField] = 10
    [TextField] = "Some Text 10"


    1. Create a combo box:

    2. Set the RowSource of the combo box to this:
      SELECT NumberField, TextField FROM Table1;


    3. Add a Button to the form: [cmbErrorExample]
      Add On Click Event:
      If Me.cmbErrorExample.RowSource = "SELECT NumberField, TextField FROM Table1;" Then
      Me.cmbErrorExample.RowSource = "SELECT TextField, NumberField FROM Table1;"
      Me.cmbErrorExample.DefaultValue = "Some Text 10"
      Me.cmbErrorExample.Value = "Some Text…

    37 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  13. PLEASE release the fix for "Bug fix needed for MS Access Update queries with WHERE clause" because we can't update hundreds of queries!!!!

    Release the fix referenced in this link below ASAP. We have numerous MS Access apps that are not functioning and can't be expected to update hundreds of queries...(multiple apps, multiple customers...).
    https://support.office.com/en-us/article/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec

    Thanks so much!

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

    See support.office.com/en-us/article/access-err..

    For updates, this is fixed for almost all channels now (a fix has been available for most users since 11/18).

  14. Presentacion de tablas de access en Power Point

    Seria necesario que las tablas de accces se puedan visualizar en Power Point sin necesidad de macros (Sin codigos). y tambien en slideshow

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  15. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Mobile  ·  Flag idea as inappropriate…  ·  Admin →
  16. [Editor] Adding the language column at keyword, ad and extension levels

    We can't see the language of keywords, ads or extensions from Editor as the column is not available at this level. The language is only displayed at the Campaign and Adgroup levels.

    For accounts with just one language it is not problematic, but when campaigns and adgroups have multiple languages we can't dispatch the data we export for keywords, ads and extensions.

    As NQS requires the data to be sent per market AND language, it is inconvenient when requesting for an editorial review.

    Could it be possible to add the hereditated language to keywords, ads and extensions in Editor? Langage…

    4 votes
    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 →
  17. Changing theme in access 365 proplus

    It seems not possible to change the theme to black in Access 365 ProPlus. I have installed on another computer Access 365 Home and I can change it there. Further, all other ProPlus applications can be changed to Black. I have set the "UI" in registry editor to 4 which enables the colour options to increase to 4 - Colorful, Dark, Black, and White. only colorful and white are available in Access ProPlus, access home there are all 4 colours available

    22 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  18. Bug Report - The graphical problem on the screen in Query Design View mode.

    The problem is happening when is moving horizontal line between Show Table area and Field area, when is holding this line with mouse button.
    During the moving of the line is copying the content of the Query Field area on the desktop area and in Access working area.
    This problem is happening on new PCs / CPU Intel i5-i7-i8 / Processor Graphics Intel HD-630/640 / Windows 10 (1803/1809/1903).
    For better understanding the problem I can send a picture of screen. Please, give me an e-mail address.

    12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  19. Fix Windows 10 1803 Frontend - Backend corruption issues

    We have some databases with a split front end (stored on local computer) and backend (stored on a server mapped via relative path) using Access 2016 (build 9126.2259). Since upgrading many computers to Windows 10 1803 the backend database constantly becomes corrupt. We have to disable the three caches referenced in the article linked below in order for the corruption to stop, but this makes file server operations much slower while also causing unnecessary network traffic. We never had this issue on Windows 10 1703.

    https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-7/ff686200(v=ws.10)

    173 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 →
  20. Where are you

    It has become obvious in reviewing this hub that Microsoft has no interest in feedback. Unless I am missing something, out of all the feedbacks provided, Microsoft has only tagged 3 for future consideration, and they are all dated years ago, and has followed thru on none.

    What is the point to this feedback channel?

    3 votes
    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 →
← Previous 1 3 4 5 46 47
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base