I have a store procedure in SQL and I would like to know what is the simplest way to execute it.
This is a set of tables that must be updated once a year, but you will not opt for the JOB because the update date will never be the same. The idea is that it be as complex as possible for the update to be executed by the client.
This is the way I have executed SQL Server stored procedures from MS Access:
Function Ejecutar_Procedimiento()
Dim qdef As DAO.QueryDef
Set qdef = CurrentDb.CreateQueryDef("")
qdef.ReturnsRecords = False
qdef.Connect = CurrentDb.TableDefs("[cualquier tabla linkeada de SQL]").Connect
qdef.sql = "EXEC mi_store"
qdef.Execute
End Function
Source: How to run a SQL Server Stored Procedure from MS Access?