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?
Voodoo_chileAsked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
<Is there a way I can link the functions and procedures to the ACCDB database?>
No, not directly

What is the issue with using a Pass through query...?
0
 
Anthony PerkinsCommented:
>> Is there a way I can link the functions and procedures to the ACCDB database? <<
You can certainly use UDF's and Stored Procedure using ADO.
0
 
Voodoo_chileAuthor Commented:
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.
0
 
Voodoo_chileAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.