Is there a way I can link the functions and procedures in the MS SQL Server to the ACCDB database

Posted on 2011-05-09
Medium Priority
Last Modified: 2012-05-11
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?
Question by:Voodoo_chile
  • 2
LVL 75

Expert Comment

by:Anthony Perkins
ID: 35725754
>> 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.

Author Comment

ID: 35725973
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.
LVL 74

Accepted Solution

Jeffrey Coachman earned 500 total points
ID: 35730271
<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...?

Author Closing Comment

ID: 35828287
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.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question