Returning a query or stored procedure result set back to MS Access

• barry.nielson

  SSC Eights!

  Points: 912

  More actions

  July 29, 2019 at 1:54 am

  #3666656

  Hi all,

  I have created a query in SQL that requires a criteria. This works well, and I've even tried putting it into a stored Procedure.  It worked there also - when I supplied the criteria to the input window, which tells me the SP is correct.

  I need to get these results available to an Access form.  However, I can't seem to link the SP to Access. Although, I can link a view. the problem is that I can't supply an input to a view.

  So, how can I provide a criteria to an SQL Query and return the records I want to a form?

  Cheers

   

   

   

   

   

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  July 30, 2019 at 2:10 am

  #3667017

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.