I changed the log on account as you suggested and IT IS WORKING:)

thank you for your help

SP29.00.3042

No good

are you login in to the database engine with windows or sql authentication.

my fox pro in on a different server then the sql server

and it is also a...

will it be possible for you to send me

how did you set up your linked server

I am overlooking something

if I select the properties for the linked server

the security setup

for the local server login to repote server login mapping

I did not enter any information

for the option

Forc a...

I can connect from my workstation and changing the path did not help

I changed the path and took out the c$ and got the same error

I used to run the same setup on a sql 2000 with no problems

and now on the...

I am using unc path

\\ppserver\c$\cn_pp\pp2000\data

the cn_pp is set as the shared folder.

again it will work only from the sql server but not from other workstations.