Consulting

Results 1 to 4 of 4

Thread: VBA-SqlServer: stored procedures, jobs

  1. #1

    VBA-SqlServer: stored procedures, jobs

    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

  2. #2
    VBAX Mentor Brandtrock's Avatar
    Joined
    Jun 2004
    Location
    Titonka, IA
    Posts
    399
    Location
    Check this out for question 1.

    Not sure about question 2, but this may point you in the right direction.

    Hope this helps,

  3. #3
    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.

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,222
    Location
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •