<

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

x

Creating and Executing a SQL Pass-thru Query

Posted on
9,142 Points
2,143 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Join & Write a Comment

Want to know how to use Exchange Server Eseutil command? Go through this article as it gives you the know-how.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month