RUN SQL Stored Procedure in Access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • petr_podskubka
    New Member
    • Jun 2006
    • 1

    RUN SQL Stored Procedure in Access

    Hi there
    I have a SQL stored procedure which I would like to run through Access.
    This procedure has a paramert.
    I created a form and by clicking a buttom I want to run this procedure but before to be able to input the parametr as well.

    I am not sure if there is any way I can do this in the Access interface or wherther I have to use VBA code(which I am not familiar with)

    Thank you very much.
    Regards.
    Pete
  • sylviedaigle
    New Member
    • Oct 2007
    • 1

    #2
    Originally posted by petr_podskubka
    Hi there
    I have a SQL stored procedure which I would like to run through Access.
    This procedure has a paramert.
    I created a form and by clicking a buttom I want to run this procedure but before to be able to input the parametr as well.

    I am not sure if there is any way I can do this in the Access interface or wherther I have to use VBA code(which I am not familiar with)

    Thank you very much.
    Regards.
    Pete

    I would like to know if you would have information I trying to find information on how can I have my SQL stored procedure through Access...

    Thank you for helping

    Comment

    • ck9663
      Recognized Expert Specialist
      • Jun 2007
      • 2878

      #3
      Originally posted by petr_podskubka
      Hi there
      I have a SQL stored procedure which I would like to run through Access.
      This procedure has a paramert.
      I created a form and by clicking a buttom I want to run this procedure but before to be able to input the parametr as well.

      I am not sure if there is any way I can do this in the Access interface or wherther I have to use VBA code(which I am not familiar with)

      Thank you very much.
      Regards.
      Pete
      it will be a little bit of both...you need the VBA to establish connection and some setting. although there are objects that can handle some of these tasks, you still might need some VBA coding to handle some stuff, ie, error handling.

      Comment

      • iburyak
        Recognized Expert Top Contributor
        • Nov 2006
        • 1016

        #4
        Try this:

        Hi everybody! Recently I was struggling with client/server issues in MS Access/PostgreSQL combination. Although Access is intuitive and easy to …


        Basically what it does, it changes text of your query every time you pass parameters.
        The best part it is ready to use you don’t need to write it yourself.

        Good Luck.

        Irina.

        Comment

        • Jim Doherty
          Recognized Expert Contributor
          • Aug 2007
          • 897

          #5
          Originally posted by petr_podskubka
          Hi there
          I have a SQL stored procedure which I would like to run through Access.
          This procedure has a paramert.
          I created a form and by clicking a buttom I want to run this procedure but before to be able to input the parametr as well.

          I am not sure if there is any way I can do this in the Access interface or wherther I have to use VBA code(which I am not familiar with)

          Thank you very much.
          Regards.
          Pete

          Look at ADP files in Access stored procedures are exposed in the GUI interface along with views you enter paramters for the stored procedure via the Forms Inputparameters property of the form

          Regards

          Jim

          Comment

          • iburyak
            Recognized Expert Top Contributor
            • Nov 2006
            • 1016

            #6
            Originally posted by Jim Doherty
            Look at ADP files in Access stored procedures are exposed in the GUI interface along with views you enter paramters for the stored procedure via the Forms Inputparameters property of the form

            Regards

            Jim
            As I understood this question it is a pass through query that runs on SQL Server side and not on Access side.

            Comment

            • Jim Doherty
              Recognized Expert Contributor
              • Aug 2007
              • 897

              #7
              Originally posted by iburyak
              As I understood this question it is a pass through query that runs on SQL Server side and not on Access side.
              Hi Iburyak,

              You're probably right of course and me way off the mark at the end of the day :).... but the poster simply mentioned 'Access' and my presumption is that they might not be aware that in Access .ADP files as distinct from mdb files were intended to work directly with SQL Server. The connection method is (universal data link) automated within the interface they might want to consider their options?

              Regards

              Jim

              Comment

              Working...