Link to home
Start Free TrialLog in
Avatar of Voodoo_chile
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?
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

>> 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.
Avatar of Voodoo_chile
Voodoo_chile

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
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.