Hello, might be simple but I don't even know if it is possible.
Would it be possible from a VBA-project in Access to:
- launch a stored procedure on the server
- launch a job of the server
Could save me a lot of time ...
Thanks
Hello, might be simple but I don't even know if it is possible.
Would it be possible from a VBA-project in Access to:
- launch a stored procedure on the server
- launch a job of the server
Could save me a lot of time ...
Thanks
Thanks Brandtrock.
My target stored procedure is stored on the server.
I wonder how I could use it.
Launching a SP from the Connection.Execute method is convenient,
but in some cases it makes code management a bit obscure.
That's why I would like to leave the SP on the server, in my special case.
Sometimes it is more convenient to handle the SP in the code.
Specially when this SP changes a lot depending on some user input.
For what it is worth, we have always found it far easier to use stored procedures and manintain them in the DB, rather than do it all from code.
You can always the code obscurity by writing a more user-friendly class, and use that class to access the SP.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber