Thank you for your feedback.
In terms of setting SQL Server as the default database format, that is currently not in scope for the Access product. We have provided and will continue to provide efficient methods to integrate your Access data with SQL server, and the team will continue to develop more features that streamline the data migration experience (see https://support.office.com/en-us/article/migrate-an-access-database-to-sql-server-7bac0438-498a-4f53-b17b-cc22fc42c979)
However, the ACE database engine has and will continue to be Access’s central data storage unit.
There are new features coming soon that will improve the Access: SQL experience, and we are excited to share this news. Please stay tuned! :)
115 votes7 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →
An error occurred while saving the commentKimY commented
Access in the API economy:
With the dramatic growth in cloud computing the need for seamless, fast integration (API’s) is in high demand. Taking advantage of these API’s within Access is brutal.
We need to be able to easily make these API calls and to be able to work with JSON, XML and other data types in Access. We need to be able to send and receive this data.
Not being able to use clients already built business logic via API’s makes it very hard to get approval for an Access front end.