Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SQL Server Strore Procedures (Access 2000)

    How can I run a SQl Server 7 Store Procedure from MS Access?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL Server Strore Procedures (Access 2000)

    From an MDB, you usually use ADO to run it. In an ADP you can run it directly. What exactly are you trying to do?
    Charlotte

  3. #3
    Lounger
    Join Date
    Jan 2001
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL Server Strore Procedures (Access 2000)

    I want to create a form with some text box and pass the texbox value to the StoreProcedure and run it.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL Server Strore Procedures (Access 2000)

    What does the stored procedure do? You can build code to pass a parameter to a stored procedure, but what do you want to accomplish? And did you want to do this in an mdb or an adp?
    Charlotte

Posting Permissions

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