Linked Server

[VBXL]

Please could someone give me a step by step guide to set up a linked server to an Access Database

 

[tlbroadbent]

SQL Books Online contains an example of linking an Access database to SQL Server under the topc of sp_addlinkedserver. It is also available online at the following link.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_adda_8gqa.asp

More info is available at

http://msdn.microsoft.com/library/en-us/acdata/ac_8_qd_12_6a44.asp

http://msdn.microsoft.com/library/en-us/adminsql/ad_1_server_4uuq.asp

http://support.microsoft.com/support/kb/articles/Q246/2/55.ASP

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.