SQL Server and SharePoint

[gregbowers]

To facilitate remote access to your Excel application's central database, it's best to avoid using Access on SharePoint due to performance and compatibility issues. Instead, consider migrating your database to SQL Server, which offers robust scalability and supports secure remote connections. SharePoint can then be utilized for document management and collaboration, complementing SQL Server's data capabilities. Update your Excel application to connect directly to SQL Server using ADO.NET or similar technologies, ensuring efficient data retrieval and manipulation. Implementing appropriate security measures, such as VPNs or Azure AD integration, will safeguard remote access. This integrated approach will enhance scalability and support remote work effectively.