<

Go Premium for a chance to win a PS4. Enter to Win

x

Executing a SQL Server Function from Within Access

Posted on
13,581 Points
2,182 Views
19 Endorsements
Last Modified:
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
Comment
Author:TechMommy
3 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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Join & Write a Comment

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month