Hi

Is subject possible?

From SQL Server, I can call the function as
Select * From dbo.udf_MyFunction(Parameter1, Parameter2, ...)

From Access front-end, I want to call this function, and use the result
table as data source for report.
My quess is, that I have to use a pass-through query for this.

Has someone any experience with this?
Thanks in advance!

Arvi Laanemets

Yes, you need to use a pass-through query using a Select query like the one
you have shown us.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)


"Arvi Laanemets" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi
>
> Is subject possible?
>
> From SQL Server, I can call the function as
> Select * From dbo.udf_MyFunction(Parameter1, Parameter2, ...)
>
> From Access front-end, I want to call this function, and use the result
> table as data source for report.
> My quess is, that I have to use a pass-through query for this.
>
> Has someone any experience with this?
> Thanks in advance!
>
> Arvi Laanemets