I use Visual Studio (VS) 2012 for development. I haven't had to query Microsoft Access 2010 in years, however, I find myself in this situation.
For select queries I like to use an .xsd file which represents a DataSet file in VS. I usually proceed by using the VS Server Explorer, opening a connection to the desired database and using drag-and-drop to pull over the stored procedures or views I would like in my dataset definition. In Microsoft Access 2010 I see views, stored procedures and functions which are draggable.
When I drag the desired select query (created within Microsoft Access 2010) onto the dataset file within VS 2012 I receive a warning stating "Parameter information for stored procedure/function could not be retrieved. Parameters collection will be empty." My select query is listed under Functions within VS Server Explorer.
How might I correct this problem? I like using stored procedures (or in the case functions in Microsoft Access 2010). My Microsoft Access 2010 select query does require a parameter to be passed. I am using other select queries (listed under Views) which do not have a parameter and I have no warnings or errors with those.
Much thanks in advance for any assistance you may offer.