Re: Setting up Ms Access Linked Server

From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
Date: Tue, 27 Dec 2005 05:26:30 -0700

Try adding it in the provider string, something like:
EXEC sp_addlinkedserver
@server ='YourLinkName',
@srvproduct ='',
@provider ='Microsoft.Jet.OLEDB.4.0' ,
@datasrc ='C:\PathTo\Your.mdb',
@provstr=';pwd=YourDBPassword;'

-Sue

On Fri, 23 Dec 2005 00:25:02 -0800, "Woo Mun Foong"
<mfwoo@xxxxxxxxx> wrote:

>Hi,
>
>Anyone can tell me on how to set up a linked server from MsSQL 2000 to Ms
>Access XP ?
>
>My Access MDB is a password protected database but doesn't use Workgoup
>Security.
>

.

Prev by Date: Re: SQL Server 2005 and SQLDMO
Next by Date: Re: No data in Sql 2005 tehre is data in sql 2000
Previous by thread: Re: SQL Server 2005 and SQLDMO
Next by thread: Can't connect from ASP app
Index(es):
- Date
- Thread

Relevant Pages

Linked Server
... I need to create a Linked Server to an Access MDB from my SQL Express. ... When I do this, I can then see the MSDE Linked Server in EM, and I can fix ... Linked Server Properties ...
(microsoft.public.access.adp.sqlserver)
Linked Server Security question
... I am new to the linked server concept and I'm having trouble with the ... Users are trying to run a report from Reporting Services whose data is ... The stored procedure gets its records ... Access mdb that resides on the c: ...
(microsoft.public.sqlserver.connect)