MS Access - Execute SQL Server Stored Procedure using Data Access Object (DAO)

Question

Good Day Everyone

How can i call the stored procedure from SQL Server Database using MS Access VBA? with and without parameters using DAO? 

Thanks and Regards

Answer 1

Use a pass-through query.

https://support.office.com/en-us/article/Process-SQL-on-a-database-server-by-using-a-pass-through-query-b775ac23-8a6b-49b2-82e2-6dac62532a42?ui=en-US&rs=en-US&ad=US

https://msdn.microsoft.com/en-us/library/bb188204.aspx

Answer 2

>>>How can i call the stored procedure from SQL Server Database using MS Access VBA? with and without parameters using DAO? 

According to your description, you could refer to How To Call Stored Procedures Using Data Access Objects