How do I call a SQL Server stored procedure from Access 2010 VBA using DAO to return a dataset?
I have an Access 2010 front end with a SQL Server 2012 backend. I have a listbox that retrieves a list of people. Right now the performance in retrieving the records has been slow. I would like to change the process by using a stored procedure call using DAO from Access VBA. Does anyone have an example of how to do this?