|
| 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
April 16th, 2010, 06:06 AM
posted to microsoft.public.sqlserver.odbc,microsoft.public.access,microsoft.public.access.reports
|
|||
|
|||
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
April 16th, 2010, 07:13 AM
posted to microsoft.public.sqlserver.odbc,microsoft.public.access,microsoft.public.access.reports
|
|||
|
|||
|
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 | |
|
|
Linear Mode
