![]() ![]() ![]() Let's take a minute to create a basic Access query against the dbo_Orders, dbo_Customers, and dbo_Employees tables first. The 'Tables' listing should look something like what you see below. If you have been following along with this tip series on Microsoft Access and SQL Server integration then you should have an Access database with the following linked tables to an instance on your SQL Server for the 2005 Northwind database. By the time you have finished reading this tip you will know precisely how to create one. This is called a Pass-Through Query in Microsoft Access. Microsoft Access gives you the ability to issue the query created in Access directly against the SQL Server database, using T-SQL commands. Imagine the implications of querying a large table or data set comprised of multiple tables in Access against a linked SQL Server record source in your environment! There has to be a better way! When querying a linked table, Access will return/load the entire table into Access before parsing the WHERE or HAVING clauses. At this point you can use the linked tables as you would any other native Access table. Thus far in this tips series on Access and SQL Server we have created an ODBC Data Source Name (DSN) using the OLEDB driver, created a System DSN for the new SNAC (SQL Native Client) driver and created linked tables in Access by using the SNAC DSN. By: Tim Ford | Updated: | Comments (31) | Related: More > Microsoft Access Integration ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |