Error when executing a job from MSAccess
Posted on 2013-06-20
I have a customer who has an Access application.
The last step of the Access application needs to start a job in SQL server.
This is what I have in my pass-through query:
SET NoCount ON ;
EXEC msdb.dbo.sp_start_job N'Upload_Book_Titles';
I get this error:
Pass-through query with ReturnsRecords property set to True did not return any records.
I have tried including a DoCmd.SetWarnings =False;- this does not work.
I do not see any default setting within my ODBC connection that I can update to resolve this error.
What command can I include in my pass-through query to resolve this error, execute this job, and complete my task?