Access database as linked server

[MarkGreen]

Hi,
I need some help setting up a linked server!
Just to give a basic overview, here is what i need to do:
I have currently got a database that is live and functioning on SQL server 2000. However, when certain data is written to a table in the database I need an exact copy to be written to another table in an access database which is (ideally) not on the same computer as the server.

I am trying to link to this access database using linked server, and then insert the neccessary data using a stored procedure.

However, I can't find any examples where an access linked server is on a different machine to the SQL server. In the "data source" field in the linked server properties it only seems to beable to link to local drive letters. Is this the case?

Any help whatsoever would be appreciated because i'm not sure if i'm going about this in the correct way!

Thanks, Mark

 

[cmmrfrds]

This link seems to indicate a permissions error on the remote server with the account on the main server. Apparently, Jet needs to write temporary files. I tried on my setup but couldn't seem to get the permissions correct.

http://www.sqlmag.com/forums/messageview.cfm?catid=8&threadid=8427

 

[LUVLES]

HI MARK,

WE HAVE THE SAME PROBLEM BUT I WASN'T ABLE TO SOLVE IT. DID YOU SOLVED IT? IF YES, COULD YOU PLEASE TELL HOW DID YOU DO IT? I REALLY NEED IT DUDE.

THANKS A LOT.