Post reply

Sql Server SP to Access

  • July 12, 2005 at 3:46 am

    #573287

    I think he means 're-create in Access, the sp I currently have in SQL Server'

    Anyway, if so, we need to know what's in the original sp.  If it's a simple query, it may be OK (unlikely) - most likely, as James said, he'll have to use queries and VBA.

     

     

  • July 12, 2005 at 5:59 am

    #573302

    It might be a good idea to post the SP you are trying to recreate, so someone could suggest a workaround.  But there is no such thing as a true stored procedure in Access.  Usually you would need to use a parameterized query or you could build a SQL statement on the fly.

    Dick Schroth

    dschroth@schrothsystems.com

    http://www.schrothsystems.com

  • July 12, 2005 at 10:10 am

    #573501

    Ahh the joy of guessing ... we will never know what he actually wanted? ... unless the poster replies back


    * Noel

  • July 12, 2005 at 10:14 am

    #573508

    Still valid point .

    Guess we'll never know.

  • July 12, 2005 at 11:10 am

    #573570

    Probably the Access feature that's most analogous to a stored procedure is the Module object.  If I were in your shoes, I'd do some research into Access modules and see whether they would do what I needed.

Viewing 5 posts - 16 through 19 (of 19 total)

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