I have a stored procedure in SQL Server that performs an update on my tables (no parameters needed and no data returned). In SQL Server it is called dbo._Test_MissingProjectIDs.
I have created an ADO connection which works fine
I'm having difficulty with the syntax in Access to execute the procedure. This is where I'm currently at and the resulting error message:
Set qdf = CurrentDb.CreateQueryDef("")
qdf.SQL = "Exec dbo._Test_MissingProjectIDs"
on the qdf.sql step I get error 3129: Invalid SQL statement; expecting DELETE, INSERT, PROCEDURE, SELECT, or UPDATE.