<

Executing a SQL Server Function from Within Access

Posted on
14,636 Points
4 Comments
3,236 Views
19 Endorsements
Last Modified:
Community Pick: Many members of our community have endorsed this article.
Editor's Choice: This article has been selected by our editors as an exceptional contribution.
Experience Level: Intermediate
5:16
TechMommy
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access is a SQL Server function. After linking to a view based on a scalar-valued function, or creating a pass-through query that executes a table-valued function, you can utilize the results of both types of functions.
19
Author:TechMommy
4 Comments

Comment

by:Francis Luo
It is a very informative video.  How to make it full screen?  It is too small to view the detail.
0
LVL 18

Comment

by:Simon
Good video. for first-time users it would have been good to include the creation of the passthru query in Access.
0

Comment

by:Timmeh
Nice! Could be very useful. Thanks!
0

Comment

by:Poorna Durga
Very useful webpage for software testing problem
0
How to run a SQL Server stored procedure asynchronously from Microsoft Access
Article by: Natchiket
When running slow stored procedures from Access it may be useful to have the application do something else rather than just show the hourglass.   In this example a form flashes a message while the stored procedure executes, and then closes itself on…
Change The Specific Printer of Access Reports Via VBA
Article by: Dale Fye
If you want to save changes made programmatically to a reports Printer property do not use this syntax: docmd.close acReport, Reportname, acSaveYes

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month