ms sql server; linked server; jet; mdw

hello,
is there anybody here who can tell me how to create linked server in
microsoft sql server 2000 to microsoft access database
(microsoft.jet.oledb.4.0);
but access database have own workgroup file; i don't know where to place a
path to this mdw file while creating linked server;
and maybe i should do something else to successfully connect;
access database is divided into two parts (mdb files) - one with business
login and other with data;
in order to get access to data part i should connect to business login part;
i'll be thankful for any sugestions;
regards,
krhThe following article will give you more information on how
to configure the linked server:
HOWTO: Use a SQL Server 7.0 Distributed Query with a Linked
Server to Secured Access Databases
http://support.microsoft.com/?kbid=246255
-Sue
On Thu, 18 Mar 2004 14:20:42 +0100, "Ryszard Halski"
<halley.fm@.poczta.fm> wrote:

>hello,
>is there anybody here who can tell me how to create linked server in
>microsoft sql server 2000 to microsoft access database
>(microsoft.jet.oledb.4.0);
>but access database have own workgroup file; i don't know where to place a
>path to this mdw file while creating linked server;
>and maybe i should do something else to successfully connect;
>access database is divided into two parts (mdb files) - one with business
>login and other with data;
>in order to get access to data part i should connect to business login part
;
>i'll be thankful for any sugestions;
>regards,
>krh
>