Microsoft quickly resolves Access and SQL Server performance glitch in February 2024 update

In the recent February 2024 updates for Microsoft 365 Apps, users encountered a significant performance issue related to Access databases linked to SQL Server tables. This problem, which manifested as severe slowdowns with DAO recordsets and the legacy MDAC/WDAC SQL Server driver, was quickly identified and addressed by Microsoft.

Access databases linked to SQL Server tables

The issue arose after the February updates were applied, leading to a drastic performance degradation when using DAO recordsets with linked SQL Server tables. Users experienced long delays when attempting to attach tables and navigate through recordsets, which significantly hampered productivity and raised concerns within the community.

Microsoft’s engineering team acted swiftly upon recognition of the problem. A similar issue had been noted in the January 2024 updates but was rapidly resolved through the implementation of a Feature gate. The Feature gate is a mechanism that allows Microsoft to enable or disable features within their software to quickly address issues without requiring a full update or patch.

The performance issue was mitigated by Microsoft through the Feature gate, restoring normal operation for users affected by the glitch. Microsoft’s proactive approach in resolving such issues underscores their commitment to maintaining the reliability and efficiency of their software suite.

For users, it is recommended to stay updated with the latest patches and updates from Microsoft to ensure optimal performance and security. Additionally, it is advisable to monitor official forums and support channels for any emerging issues and the corresponding fixes provided by Microsoft.

Microsoft’s rapid response to the Access and SQL Server performance issue demonstrates their dedication to customer satisfaction and software excellence. By leveraging Feature gates and maintaining open communication with their user base, Microsoft continues to uphold the trust and reliability that users expect.