Configuring a Linked Microsoft Access Server on SQL 2005 Server - Running a query against the linked server

(Page 5 of 6 )

There are two options for accessing the tables in the database and running queries against them. You may use the Transact SQL openquery() function, or use a syntax similar to the four-part name without specifying two of them.  Both methods are shown with the results in the next two pictures. The openquery() function works just like the pass-through query against the linked server. The four-part syntax is used without referring to the catalog and schema, since schema in SQL 2005 server have a different connotation than in the earlier versions and Catalog is not relevant.

Openquery(Linked_Server, 'Query')

 

 

Using Four Part Syntax

Next: Using the Management Studio to set up a Linked Server >>
 

More Microsoft Access Articles
More By Jayaram Krishnaswamy

Comments On: Configuring a Linked Microsoft Access Server on SQL 2005 Server

· Working on single databases will be mostly for small businesses and anywhere you...    · Wonder if you have any idea why SQL Server posts a a reference to c:/windows/sytem32...    · I am Jayaram Krishnaswamy. Somehow the authentication to login to leave a message...    · I read this with great enthusiasm but was saddened because it does not have an...    · Hi,Thanks for this article! It is exactly what I want to do. But it doesn't work...    · Well, my error comes out in english, but I think it matches yours. The handling of...    · Well, if you find something about this issue, please post and let me know ;)Quân   >>> Post your comment now!