use an inline table-valued function in a .mdb database (1 Viewer)

I have loads of experience with Access but very little with SQL server, so please bear with me....

I am using SQL Server 2005 and Access 2002. Using mdb, NOT adp.

I have created a paramaterized table-value function in SQL server, named
fnTrainingSummary3

The function based on a View named TrainingSummary3c. The function's only purpose is to allow the user to filter the view using EmployeeID as a parameter. Trying to filter out everything server-side except the training data for that one employee that the user will choose.

So, in the SQL server manager, I can see that the function is there.... but how do I use it from Access???? I thought maybe it would link, just like a Table or a View, but it's not there in the list when I try to link from Access.

In Chipman and Baron's "Microsoft Access Developer's Guide to SQL Server", pg 416, there is an example where they indicate I would just use:

SELECT * FROM fnTrainingSummary3('12345')

Click to expand...

where 12345 is the EmployeeID. Which would lead me to believe that my Access database should be seeing that fnTrainingSummary3 as a table...?


Am I going at this totally the wrong way?

Hi there,

I dont think you will be able to see it from access, not with a .mdb anyway.
However you will be able to execute it with a bit of VBA and ADO.