<

Executing a SQL Server Function from Within Access

Posted on
13,733 Points
2,334 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
Comment
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

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Join & Write a Comment

Here is the list of top 5 best SQL recovery software with their key features and licensing details. One can choose the specific SQL database recovery program according to their need.
State of play: Databases ensure data integrity and relationship through both primary and foreign keys, and MS Access is no exception. Well, that's not completely true ... A primary key should not be null.  - No problem, the NOT NULL constrain…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month