Executing stored procedure from MS Access

  • Is it possible to execute a Sql Server 2000 stored procedure or DTS package from a MS Access db that is linked to the Sql Server tables?

  • quote:


    Is it possible to execute a Sql Server 2000 stored procedure or DTS package from a MS Access db that is linked to the Sql Server tables?


  • Are you using an access adp file?

    Is it possible to execute a Sql Server 2000 stored procedure or DTS package from a MS Access db that is linked to the Sql Server tables?

    [/quote]

  • 1. Pass-through query

    2. Programming Modules in Access using VB.

  • Pass-through query works great!

    Just the solution I've been looking for. Thank you!

    quote:


    1. Pass-through query

    2. Programming Modules in Access using VB.


Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply