<

Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Creating and Executing a SQL Pass-thru Query

Posted on
9,050 Points
2,057 Views
10 Endorsements
Last Modified:
Experience Level: Beginner
5:16
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pass-thru query. This video covers the basics of creating and working with pass-thru queries.

Video Steps

1. The video first shows the viewer how to create a pass-thru query in Access.

2. The data in the SQL Server table that the pass-thru query will return is displayed in SQL Server Management Studio.

3. We then create the T-SQL string in the pass-thru query and create an ODBC data source that will be used to connect to the SQL Server.

4. Finally, we store the ODBC connection string in the pass-thru query so that the pass-thru query can be run at any time.

10
Comment
Author:TechMommy
0 Comments

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Join & Write a Comment

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
The core idea of this article is to make you acquainted with the best way in which you can export Exchange mailbox to PST format.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month