<div>
Thanks for clarifying this issue. &nbsp;A related follow-up question. &nbsp;Is it possible to open a stored procedure as a datasheet AND pass it some parameters or can you only open sprocs that require no parameters?
</div>


Thanks for clarifying this issue.  A related follow-up question.  Is it possible to open a stored procedure as a datasheet AND pass it some parameters or can you only open sprocs that require no parameters?

<div>
Well, bear in mind that it's something I'd never want to do anyway... I certainly don't know of a way that you'd do that (without the parameter prompts popping up at you).<br />
<br />
You should really be looking to use forms for such things.<br />
You gain so much more control.
</div>


Well, bear in mind that it's something I'd never want to do anyway... I certainly don't know of a way that you'd do that (without the parameter prompts popping up at you).

You should really be looking to use forms for such things.
You gain so much more control.

<div>
Thanks, LPurvis for your prompt responses. &nbsp;Answer accepted.
</div>


Thanks, LPurvis for your prompt responses.  Answer accepted.

<div>
<div class="content wysiwyg-content">
I am using Access 2002 as an adp front end to SQL Server 2000. &nbsp;I want to create a recordset in ADO using parameters selected by the user and display it in a datasheet view, the same display result you get from DoCmd.OpenQuery and DoCmd.OpenStoredProcedure.<wbr />
</div>
</div>


I am using Access 2002 as an adp front end to SQL Server 2000.  I want to create a recordset in ADO using parameters selected by the user and display it in a datasheet view, the same display result you get from DoCmd.OpenQuery and DoCmd.OpenStoredProcedure.

Display an ADO recordset as a datasheet in MS Access data project

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.