Server Explorer and MS Access (1 Viewer)

bbulla

I'd rather be golfing
Local time
Today, 13:21
Joined
Feb 11, 2005
Messages
101
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,
 

DJkarl

Registered User.
Local time
Today, 12:21
Joined
Mar 16, 2007
Messages
1,028
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.
 

bbulla

I'd rather be golfing
Local time
Today, 13:21
Joined
Feb 11, 2005
Messages
101
Yes, it appears the Nz function causes issues. Thanks.
 

Users who are viewing this thread

Top Bottom