projecttoday
Programmer
I am a newbie to Access 2007 FE/Sql 2008 Express BE and I would like to know how to create a form in an Access ADP that is bound to a stored procedure.
I migrated some tables and data to Sql Server successfully. I created an Access Data Project. I went back to Sql Server and created a stored procedure because apparently you can't create a 2008 sp in 2007 Access. Now the question is, how do I make a form in my Access ADP using the sp as the record source instead of a query. I have tried searching but can't find this answer, which I'm sure is very simple.
I migrated some tables and data to Sql Server successfully. I created an Access Data Project. I went back to Sql Server and created a stored procedure because apparently you can't create a 2008 sp in 2007 Access. Now the question is, how do I make a form in my Access ADP using the sp as the record source instead of a query. I have tried searching but can't find this answer, which I'm sure is very simple.
