If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Accessing SQL Server Table-Valued Function from Access front-end
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 |
#2
|
|||
|
|||
Accessing SQL Server Table-Valued Function from Access front-end
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|