>>Hmmm... I just looked on my PC and choose Books on line and it came up. Maybe I did install them.
>>
>Yep, it is a part of the SQL Server client installation by default. It is VERY informative and covers LINKED SERVER extensively.
>
>Mike

I have been working on this all after noon, and still can't get it to work. Unfortunalty there is no example of exactally what I want to do, all the samels are for linking to another SQL server or linking to an Accessdata base.

This is really wierd... If I use the View designer in Ent Manager I am able to drag the table from the linked server to the view. In the designer it creates a query like...

With me putting a catalouge name into the linkedserver...

SELECT eemast1.* FROM
NJDATA.BOB. .eemast eemast1

The table box in the designer doesn't have any of the field names listed. When I run this query I get the error message:

OLE DB Provider 'MSDASQL' doesn't contain the table "'BOB'\'eemast'"

*****************

If I don't put a catalouge name when draging the table to the view designer I get a query like this...

SELECT * FROM
NJDATA.\\svrhomer\TotalHr\Data. .eemast

Now, I do get all the field names in the designer. But, if I select to run the query I get....

Syntax error in FROM calse near \.

I tried to escape all the back slashes with a back slash but still get the syntax error.

************
I don't know how you got it to work... Did you use the VFP Driver with FREE tables.

What version of the driver did you use?

Do you have SQL7 SP1 ???

Ug.. I really apreciate the help.

BOb