<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Creating and Executing a SQL Pass-thru Query

Posted on
10,803 Points
2,807 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
Author:TechMommy
0 Comments

Featured Post

Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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…
If your application will be used by financial auditors, then never ever use the delete functions to remove incorrect documents from your ledgers because financial auditors will require to audit, even cancel or reject documents and reasons for their …

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month