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 Access on MAC

    At this moment I'm a subscriber of Office 365, but always I worked with Ms Access. Now, I have a Mac book Pro and is not possible install it. I also work with other tools, like Excel, but I would like to see the MS Access to be compatible with IOS system, because it's a wonderful tool, and I can't have both systems (Windows and Mac).

    11 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 →
  2. MS Access

    I would like to have a cloud version of MS Access and really need it for my business could you please indicate a timeframe ?

    21 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Cloud  ·  Flag idea as inappropriate…  ·  Admin →
  3. Re-Instate Pivot table view in Access 2016

    Please restore this feature, clearly by the number of ignored CUSTOMER requests in the past to restore, you clearly dont value your user are are technically unable to honor their wishes !!!

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

    As you are probably aware, Pivot Charts and Pivot Tables have been removed from Access 2013 because the technology they relied on was deprecated (Office Web Components).

    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]

  4. When will Access have a mobile version?

    I have been using database manager for many years from Smartlist To Go on the palm, to HandBase on Android and now Airtable cross platform Windows, Apple and Android. None of them is as powerful as Access. Really, really needed a mobile version because most of the time I use the database is with my phone. I only go to my computer to look at larger databases. Please let us know when will a mobile version for Android and Ipad come out? please please!!

    2 votes
    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 →
  5. You need to get MS Access on the web or it's a dead product......

    You need to get MS Access on the web or it's a dead product...... MS Access used to be great to make apps on the Local Area Network(LAN) using VBA and (I used) SQL Server. But now people need to get to that same data from the web... from anywhere.... If Access can't be moved to the web(including it's interface, not just database) it's a dead/dying product. I currently use ASP.NET with C# and SQL Server to re-create all that I've done with MS Access but I hate to see MS Access die. There is a drive right now to…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    No Current Plan  ·  0 comments  ·  Cloud  ·  Flag idea as inappropriate…  ·  Admin →
  6. Shut down this product

    You have no intention to evolve this product nor listen you your customers
    So avoid the frustration and shut down the site as well as the product

    1 vote
    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 →
  7. In some Access export commands path length is limited. Could you remove those limitations?

    In some Access export commands path length is limited. Could you remove those limitations?

    ' works:
    
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Mitarbeiter", "C:\Users\Gerrit.Viehmann\Desktop\Very looooooooooooooooooooooooooooong directory\Very loooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooong filename.xlsx"
    ' Error 2006:
    DoCmd.TransferText TransferType:=acExportMerge, TableName:="Mitarbeiter", FileName:="C:\Users\Gerrit.Viehmann\Desktop\Very looooooooooooooooooooooooooooong directory\Very loooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooong filename.txt"
    ' works. Add one ‘o’ and it doesn’t:
    DoCmd.TransferText TransferType:=acExportMerge, TableName:="Mitarbeiter", FileName:="C:\Users\Gerrit.Viehmann\Desktop\Very looooooooooooooooooooooooooooooooooooooooooong filename.txt"

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for posting.
    The limitation in this case is on the filename itself, not the path. For file types, the database engine treats the file name as the table name in an external data source, so it enforces the limit on table name length, which is 64 characters.
    At this point we have no plan of changing such a fundamental behavior in Access.

  8. Enrich VBA, take it out of maintenance mode

    So VBA was put into maintenance mode, Microsoft moved programmers to .NET. That was years ago. Office Desktop apps are still selling with VBA and yet VBA has not been enhanced - the two environments do not compete and I have not seen .NET intrinsically replace VBA and packaged as Office's internal programming language. There are so many ways that VBA can be enhanced. Linq can be added so that we are not typing mutiple quotes in unverified statements isolated in a string. String Interpolation. Managing large chunks of text in strings etc.. etc...

    47 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 →
  9. 3 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 →
  10. I am a former DBASE programmer. I find that language to be very powerful and yet the language in ACCESS does not support it.

    I could create a PRG file that would perform much as an application ...
    I am gradually learning the intracicies of ACCESS objects and how to build embedded queries inside of queries. I am also able to build some pretty exotic filters at this point. The Do While Loops coupled with nested If statements in DBASE enabled me to perform some pretty complex real world processing, that I find more n more complicated to replicate using ACCESS. It would be the BEST OF THE BEST if there was a bit of the same syntax as the Ashton Martin - DBASE.…

    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 →
  11. Please provide a link to datasets to be able to follow along with the MS Access tutorials

    I cannot follow along with all the steps given I do not have a dataset to work with that is similar to the tutorials.

    1 vote
    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 →

    Thank you for posting.
    Most Access tutorials published by Microsoft refer to the Northwind database which is available as a template in Access.
    Use the search box in the templates page to search for it if it doesn’t show up in the first page.
    You will find this database sample to be highly useful in learning Access and following tutorials.

    Hope that helps,
    Michal [MSFT]

  12. 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 →
  13. provide an offline trial install of individual office products. Not everyone can just sign up for free trials of office365

    Seriously. I should be able to install a trial without having to dish out a credit card.

    1 vote
    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 →
  14. Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt

    i have developed a application with help vs2010 & access2013 it works fine after i update office 365 im facing so much of issues with application like microsoft oleb 12.0 is not registered on the machine and then i installed 2007 and 2010 driver components after the issue is went off & now i got new issue like cannot open database" please help me to fix it

    2 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 →
  15. VBA string variable can not handle strange characters, Long text field (Memo field)

    A VBA string containing a long text variable should be able to be handled in VBA without reading the variable content as part of the string.
    For now Access vba apparently reads the variable content, and a long variable (string) contains odd characters it either gives an error or populates the variable text truncated.
    The only way today handle such long text strings with odd characters is unfortunately enforcing use of ADO 3.6 Library and using late binding and record sets, then access vba do not read the variable content as part of the string.

    1 vote
    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 →
  16. Add the following ability to Power BI Desktop

    Add the following features to Power BI Desktop

    1) Update tables (via Code, Copy paste, by typing data etc)
    2) Password protect PBIX Files
    3) Allow Excel to connect to the Data model in Power BI Desktop file
    4) Introduce a UserName Function in Power Query
    5) Retire Access

    1 vote
    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 →
  17. Bring Access to the year 2017

    OK, enough of COM controls and VBA programming. The controls need a complete overhaul that look like and act like year 2017 controls not 1981 controls. We need more controls that you would find in .net interface. The chart control, datashets and almost all other controls need to be moved out of the COM world. Creating a dashboard in near impossible with the current controls and layout handling.

    Also VBA is ok but very limited compared to .net. Both are your products why not integrate them.

    We need a true grid control, better comboboxs, true PDF support, better and attractive…

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

    Thanks for sharing your thoughts and ideas with us.

    However as written, we feel that this suggestion is not actionable. Please feel free to create new itemized suggestions that are more actionable.

    Thanks,
    Michal [MSFT]

  18. Ctrl+A in a textbox should select all text instead of all records

    Currently, when I'm in a form's textbox and I instinctively hit Ctrl+A to select all text (just like any other Windows application), nothing happens. Or so you may think, in fact everything happens! All records get selected, and if you dare hit the wrong button while you think you have selected all text of the textbox, woe is unto you.

    Should Access really be different from all other programs out there? Why should a user think that when in a textbox and hitting ctrl+A it won't select the text?

    Of course, there are workarounds (like a VBA function that hijacks…

    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 →
  19. Please restore the Pivot Tables to MS Access 2013

    Many people in my off use the pivot tables that I produced in MS Access, since the change they are now just useless datasheets. I can not expect the staff in the office to export the data and convert it to pivot tables in MS Excel. Please return this feature ASAP. Thanks

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

    We realize that Pivot Tables and Charts have been a great feature and many Access users found them to be highly useful.
    As you may already know, they have been removed as the technology they relied on, was no longer supported (Office Web Components).

    At this point we have no plan to bring Pivot Tables and Charts back. However we are looking into ways to improve and modernize data visualization in Access.

    Stay tuned.

  20. Mac Office 365 pricing - Why am I paying for Access & Publisher??

    Mac users cannot download Access or Publisher, but we are paying for the full subscription price that includes those apps - if you are not going to provide those apps, you need to change the pricing and/or offer a different tier subscription to Mac users.

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

Access (Desktop Application)

Categories

Feedback and Knowledge Base