Article ID: 246255 - View products that this article applies to.
This article was previously published under Q246255
This article has been archived. It is offered "as is" and will no longer be updated.
This article describes how to use a Microsoft SQL Server distributed query to retrieve data from a secured Microsoft Access database.
Microsoft SQL Server version 7.0 provides you the ability to perform queries against different databases by using OLE DB providers. You query databases by using:
Steps to Query Secured Microsoft Access Database
Microsoft SQL Server 7.0 Books Online; topics: "sp_addlinkedserver"; "sp_addlinkedsrvlogin"; "OpenQuery"; "OpenRowset"; "OLE DB Provider for Jet"
Article ID: 246255 - Last Review: February 27, 2014 - Revision: 4.4