Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 MS Access DB as a Linked Server

Author  Topic 

magesh
Starting Member

23 Posts

Posted - 2005-09-26 : 00:09:23
Hi all,

I want to know whether i can use MS access database as a linked
server database.

iam having few important tables in MS access and many tables in
SQL server. i want to use single query statements for
all these tables.

i.e i have to use MS access 2000 tables along with SQL server 2000
tables.

pls tell me it is possible or not

regards
Magesh

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-26 : 00:15:46
Look for OpenDataSource or Linked Server in Books On Line

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -