Posted by maxvalery on 11/22/81 11:57

Hi,

Looking for a quick and dirty on running an Access database as a linked
server in SQL Server. Basically, the majority of my stuff is in SQL
Server, but there is one lingering nightmare-of-an-Access-database no
one wants to touch.

I just want to create a linked server to use the Access db.

So far I have not found a way to connect (under Security -> Link
Servers in SQL Server), though I tried all kinds of drivers, connection
strings, etc. What do I put for Product Name, Data Source, Provider
String, (Location, Catalog)?

Thanks a bunch.

• Next in forum: Are these DB's required??
• Prev in forum: specjalista od mssql2000 na jednorazowe zlecenie
• Thread view: Running MS Access db as a Linked Server on SQL Server

[Reply to this message]