Accessing SQL Server Table-Valued Function from Access front-end

  • Thread starter Thread starter Arvi Laanemets
  • Start date Start date
A

Arvi Laanemets

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Access Front - Sql Back End 6
Report refresh crashes Access 2007 1
access front end and sql server back end 6
Access 2007 Strange Report Design Behavior 8
Access 2003 and SQL Server 2005 and DAO recordset 1
MS Access Front End - SQL Server Backend 7

Back
Top