run a job in sql server

mana

Registered User.
Local time
Today, 14:49
Joined
Nov 4, 2014
Messages
265
Hello

i have a form with some data in it from sql server. these data will be updated through a job in sql server. I want to know if it is possible to put a button in ms access and run this job in sql server by clicking on this button? can you guide me please?
thank you
 
You can use an action Pass through to execute any code available on the SQL server.
 
If by "job" you mean a Stored Procedure there are multiple ways to do it.

As namliam suggested, there is the Pass Through query. Another alternative is an ADO Command.
 

Users who are viewing this thread

Back
Top Bottom