VBA – Access 2013 – Programmatically assigning a Form’s (DAO RecordSet) Record Source to the result of Stored Procedure (ADO RecordSet) executed on a remote SQL Server triggers “Run time error 31 – Data provider could not be initialized” error message.

Suppose we have this scenario where a local Access database uses Forms bound to SQL serverdata sources: –  a company has developed a front-end application based on MS Access 2007 and VBA, which has been   distributed to end-users as an ADP file; –  its back-end data source runs on SQL Server; –  on the client side,…

6