<

Executing a SQL Server Function from Within Access

Posted on
14,265 Points
2,865 Views
19 Endorsements
Last Modified:
Awarded
Experience Level: Intermediate
5:18
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

Expert 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

Expert 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

Expert Comment

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

Expert Comment

by:Poorna Durga
Very useful webpage for software testing problem
0
I recently had a few questions about how to quickly check the buckets on a particular partitioned table before performing a manual split or merge to make sure there will be no data movement and came up with the code below.
A description of how I fixed an Azure AD Connect password synchronization error.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month