PowerQuery is the best improvement for collecting data for Excel since many years. I would love to use it in Access too, without using Excel.
I would like to extract data from SAP, WEB, CSV-Files, collect all files from a folder, de-pivot files... Any ETL job PowerQuery supplies für Excel, but directly in Access!
(I posted this two years ago using other words)

ADD SQL SERVER AS A DATA CONNECTOR - The Access team is currently evaluating the use of data connectors in Access, (https://youtu.be/j5UAv4yY5RY?t=2155), and we need your support to get them to include SQL Server as an option! PLEASE VOTE for this idea, every vote counts!

Mac needs an amazing database software and time and time again, you still don't create a version for Mac! MS Remote Desktop is not ideal when you need to use Access all the time! Look at everyone on Mac that is suffering. JUST MAKE A MAC VERSION.

After the latest update to Office 365, we can no longer use the Windows common control C:\Windows\SysWow64\MSCOMCTL.OCX). When opening an Access 2016 database that uses that Common control, it now says that you don't have the license needed to use this ActiveX control, and only blank forms are shown.

This common control has worked for decades in office 2007, 2010 and 2016 up until now.

The version is 1707 (8323.2962).

When connecting to a commercial database such as Oracle, it may be trouble if all the columns of the table are not displayed.

Currently (Access/Office 1706), the only formatting capability for column headers in datasheet view is with the DatasheetColumnHeaderUnderlineStyle property, and this only seems to work for value 8 (Double Solid). It would be great if some extra capabilities could be added:
1. Set HeaderHeight (absolute or relative to normal row height, f.i. twice normal).
2. Options to wrap & align text within Header.
3. Set Background color / Font bold & color.

Of course more comprehensive header formatting is imaginable, but these basics would already be a great improvement.

Thanks, Hans (Netherlands)

Edit Access db / vba code within Visual Studio / VS Code with the rich IDE features that this implies.

Here's a couple of examples:

https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/11380389-create-64-bit-compatible-versions-of-mscomctl-and

https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/7162465-enable-collaboration-with-others-editting-in-excel

There are several similarities between Access and Excel, but Excel has always, and continues to get higher priority when it comes to enhancements and support.

scrolling with the mousewheel and with moving the progress bar does not work since the newest automatic update - version access 16.0.8326.2073!!!
FIX THIS BUG PLEASE ASAP!!!

In Access 2016, the check box control sizes with the row height in a datasheet. This looks extremely brutal.

Could someone look into this.

Thanks.

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.

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

Filemaker is a subsidiary of Apple Inc. Access databases have more users. I have been using Access databases for the last 15 years. Could Access database product become an independent subsidiary of Microsoft Inc., not just part of Office 365? Hate to see this product die.

Currently to work with XML objects from API calls we have an object model from referencing MSXML6.dll that make iterating through the response easy. With JSON we can only get strings of data that we have interpret. If you created MSJSON.dll for us we could manipulate JSON data as easily as XML and make life easier for developers dealing with API calls.