Configuring a Linked Microsoft Access Server on SQL 2005 Server - Setting linked server options

(Page 4 of 6 )

In addition to finding information about linked servers, you can also configure the various options for the linked server once it is added to the Linked Servers collection. The syntax for this is:

sp_serveroption [@server = ] 'server' 
,[@optname = ] 'option_name'     
,[@optvalue = ] 'option_value' ; 

A linked server has many properties that can be set. Please refer to the Book On Line to find the whole list of options. Some of the values that may be set in the Management Studio are shown in the figures that are included in this section. This next picture shows the default properties conferred by running the sp_addlinkedserver described in the beginning. The first column shows the options and the second column their values.

Now if you run the sp_serveroption as shown here, you will be changing the 'Data Access' option from being true to false.

The result of running the above stored procedure changes the 'Data Access' option as shown in the next picture.

Next: Running a query against the 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    · I'm having extreme difficulties making a linked server connect to a Simply...    · If you are struggling to link to Access 2007 substitute Microsoft.ACE.OLEDB.12.0...   >>> Post your comment now!