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:
Am I going at this totally the wrong way?
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:
where 12345 is the EmployeeID. Which would lead me to believe that my Access database should be seeing that fnTrainingSummary3 as a table...?SELECT * FROM fnTrainingSummary3('12345')
Am I going at this totally the wrong way?