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. MS Updates are killing us

    In Dec... Your update wiped out our ability to query. We go through it. Last month SQL Server wouldn't query. We got through it. NOW On particular NEW MS OFFICE Installs my query is returning Gargage. I have the details with pictures. But I am recommending we shut off MS updates to both of my clients. If this "bug" is not fixed and it spreads to the whole company computers, we stop working.

    No place for me to attach the graphic details of the NEW BUG.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  2. My access Query

    My access Query with a wildcard is not working. Microsoft had me to change SQL and still not working.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  3. Bug with Office update 2005 build 12827 - Decimal data type enforced in ADO recordset based on passthru query

    In my testing
    ODBC connection to Postgres v11
    Create a passthru query "SELECT COUNT(id)::INTEGER AS counter FROM foo"
    Mark query as returning records
    Open ADO recordset on above query

    Result:
    rs.Fields("counter").type = 20 ' DECIMAL ?!
    rs.Fields("counter").value = ""

    Same error with "SELECT COUNT(id)::BIGINT AS counter FROM foo"

    Current state:
    Have to revert MSO on 20+ backoffice client machines and hope that ADO will be reverted as well.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  4. add "Find and Replace" functionality in Queries "SQL view".

    It will be really helpful to change/correct table names/references quickly.

    Many times I need to change the base table names to a different one in a complex query with formulas that refer to table names. Currently, I need to copy the SQL to notepad, make the changes and paste it back in the SQL view. However, this resets the column ordering in Datasheet view. I think "Find and Replace" is quite basic function to have while working in "SQL View".

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  5. Add Tables Task Pane scroll wheel should scroll the list

    Update the Add Tables Task Pane so if you've clicked into the list and scroll the mouse wheel it scrolls the list. Even better if the mouse is over the list and you scroll the wheel it should scroll the list.

    Also arrow keys should allow you to move up and down on the list after you've click on an entry in the list.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  6. Easiest way to split the Outlook PST files

    If you looking at the easiest way to split the Outlook PST files then use MailsDaddy PST Split Tool. It is a most popular single wizard application, which easily divides the Outlook PST file according to date, folder, size, and email id. The software is compatible with all editions of Windows OS and MS Outlook.

    More Info- https://www.mailsdaddy.com/pst-split-tool/

    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 →
  7. Best way to migrate NSF to Office 365 cloud

    If anyone wants to migrate Lotus Notes mailbox data into Office 365 mailbox then try NSF to Office 365 Migration Tool. It easily adds and browses the NSF mailbox items and convert to Exchange Online cloud platform without losing any data. It easily performs with all versions of Windows OS and compatible with all editions of Lotus Notes.

    More Info- http://www.nsfto.com/office-365/

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  8. Please add OFFSET and FETCH to queries

    It doesn't need to be as complex as SQL Server, but pagination would be nice Something like:

    SELECT Customers.*
    FROM Customers
    ORDER BY Customers.Name
    OFFSET 20 FETCH 5;

    This would be so amazing.

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  9. Use F5 to run a query

    When switching between SQL Management Studio and an Access front end I find myself pressing F5 to run the Access query as I've been working in the other window - would be good if F5 ran the query in Access as it does in SQLMS

    11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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 →
  11. Please at least quadruple the number of database object handles available in Access

    I frequently run up against the 2048 handle limit (and from the online searching for how to resolve this, it's clear that I'm not alone). PLEASE INCREASE the number of object handles available to Access.
    I'm supporting a reporting database that links to poorly designed tables (survey data in hundreds of fields that should be stored as records) in a vendor database that I have no control over. To make the data usable, I'm having to restructure the data, appending multiple union queries in order to get the data into a vertical format needed for our reporting needs. If I…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  12. Right click DUPLICATE a table, query, etc

    Right click DUPLICATE a table, query, etc. Instead of Copy/paste.

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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…

    6 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 →
  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. Perform subquery first, and then only apply outer query (with outer query clauses) on results of subquery, for faster, better queries

    When I use a subquery in a query, I expect the outer query to only work on the results of the subquery. However, today, it appears that the outer query (the WHERE clause in particular), is not being strictly run on just the results of the subquery. Instead, the join in the subquery appears to be being ignored, and the WHERE clause is run on the much bigger dataset of the subquery minus its join. This is counter-intuitive and probably incorrect. Please fix this. I had a subquery that only returned two rows, but it appeared Access was performing an…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  16. kth Percentile function

    Create an function to calculate kth Percentile as in excel that can be used in queries to calculate percent of grouped values

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  17. SQL editor navigation from Create > Query Design

    Create > Query Design serves a modal popup requiring dismissal in order to opt to open the SQL text edit window. It would be nice to save a click by having an option to select SQL view, which would dismiss the table selector and open the SQL text editor

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  18. Increase maximum database size to 4GB and increase maximum Query size past the current 1GB limit

    I have a 78 million record 2 field table that indexes both fields fine. When that table is 82 million records, neither field will index because of a query limit error. The 1 GB query limit must be interfering with the indexing of a table that would otherwise not violate the 2 GB limit?? Also, increase the size of the access database container to 4GB....not asking for SQL Server replacement, just something we can work with. MS upsized and oversized Excel years ago.

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  19. Allow the use of tables in update queries without requiring them to be writeable

    When executing an update query with multiple tables, all tables are currently required to be writeable.

    Please allow us to use read-only tables and queries as a source of data for update queries, e.g.

    UPDATE MyWritableTable rw
    INNER JOIN MyReadOnlyTable ro ON ro.ID = rw.ID
    SET rw.Field1 = ro.Field1

    Since there are no write actions to MyReadOnlyTable, this query should not require it to be writable, but it does.

    The current behaviour is a common source of misunderstanding (I often see questions about it on Stack Overflow), and limits the ability to update/merge in data from read-only data sources.

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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.

    9 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 →
← Previous 1 3
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base