Hi,

I created a query in my MS Access database. I'm trying to add the query to a dataset I've created in VS2008 by dragging it from Server Explorer into my dataset.

My problem is that my query shows up under 'Functions' (ie. NOT under Views), and when I drag it into my dataset I get a Merge Data Objects Issues message with the following warning:

Parameter information for stored procedure/function could not be retrieved. parameters collection will be empty.

I don't have any parameters in my query, but I am using the Nz function in the query.

Any ideas of how I can add this query to my VS project?

Thanks,

VS can't handle any VBA functions in the query. You won't be able to use them and get the query to work in Visual Studio.

Yes, it appears the Nz function causes issues. Thanks.