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

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
 

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

Using a table-valued function of a linked SQL Server database 3
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Access as a Front-End 7
Keeping Access Running Between SQL Server Reboots 3
Access front-end and SQL Server back-end table lock 2
MS ACCESS Front end With SQL Server Back end 9
using Access 2007 as front-end to SQL Server back-end 15
Access Front - Sql Back End 6

Top