Voodoo_chile
asked on
Is there a way I can link the functions and procedures in the MS SQL Server to the ACCDB database
I am using an ACCDB database to connect to a MS SQL Server 2005/2008 database using an ODBC connection. I can link the tables in SQL Server. However, I can only use the functions and procedure in MS SQL Server database when using a pass-through query. Is there a way I can link the functions and procedures to the ACCDB database?
ASKER
Thanks, I do know the ADO can achieve this. Is it mean I cannot link the UDF's and store procedure to the ACCDB? I would like to confirm there are no such links in ACCDB.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This solution confirms that the function/store proc cannot be directly linked to the ACCDB file and the pass-through query is the only way to use them.
You can certainly use UDF's and Stored Procedure using ADO.