Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    130

    Question Unanswered: queries to SQL server stored procedures

    using an access 2000 .adp and a SQL Server 2000 backend...

    have some queries in a .mdb that i need to use in the .adp

    i can put the sql string from the query into the stored procedure but my forms sources was the queries. so my question is it possible to use the results returned from a stored procedure as the row source of a form?

  2. #2
    Join Date
    Sep 2003
    Location
    Cobalt, CT
    Posts
    7

    queries to SQL server stored procedures

    in an adp you can have a stored procedure as a data source. There is also a property where you can set the parameters for the stored procedure, although I have had better luck setting the record source programmatically to something like:
    EXEC spname param1, param2

    Dick

  3. #3
    Join Date
    Sep 2003
    Location
    Cobalt, CT
    Posts
    7

    queries to SQL server stored procedures

    in an adp you can have a stored procedure as a data source. There is also a property where you can set the parameters for the stored procedure, although I have had better luck setting the record source programmatically to something like:
    EXEC spname param1, param2

    Dick

Posting Permissions

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