114 votes7 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →
Thank you for the feedback. These requests have been an ongoing discussion with the team, both internally and externally. Especially with our continuously increased focus on establishing a stronger Access-SQL experience, we do plan to have some requests on this work looked further into within the next year. We will keep you posted with specific feature designs in scope as well as timelines. In the interim, you can continue checking our public roadmap for feature updates.
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! :)
An error occurred while saving the commentSam Smith commented
If this is going to happen - great - but keep the Access QBE designer as a base as it is better than the SQL Server Studio one.