Hello,

I need advice on how to connect my Excel VBA application to a remote SQL Server database securely. What steps should I take to ensure efficient data access and maintain security?

I am interested in best practices for migrating my current Access database backend to SQL Server to improve performance and scalability.
Are there specific considerations or techniques I should be aware of? I would like to know if SharePoint can effectively integrate with SQL Server for remote access; particularly in the context of Excel VBA applications. http://www.vbaexpress.com/forum/forumdisplay.php?94-SQL



Any advice on configuration ; compatibilit would be greatly appreciated.




Thank you