OLEDB Jet For Access

Hi all,
I am looking for a definitive guide to set up a linked server in SQL Server
2000.
I want to add a linked server to an Access (95) database
I have managed this on our production server (although I keep getting errors
occasionally & have to restart the server service), but on a vanilla test
server I cannot get it to work.
I would like to understand why the production server is OK, but the test is
not.
What do I have to install first to make this work?
Also, is there an idiot's guide anywhere ?
Hi,
Use Component Checker to verify MDAC installation.
Install a latest Jet pack update or MDAC.
You can find it on http://www.microsoft.com/data
Use sp_addlinkedserver and sp_dropserver instead EM. (read BOL)
Tomasz B.
"CCA Dave" wrote:

> Hi all,
> I am looking for a definitive guide to set up a linked server in SQL Server
> 2000.
> I want to add a linked server to an Access (95) database
> I have managed this on our production server (although I keep getting errors
> occasionally & have to restart the server service), but on a vanilla test
> server I cannot get it to work.
> I would like to understand why the production server is OK, but the test is
> not.
> What do I have to install first to make this work?
> Also, is there an idiot's guide anywhere ?
>
>