Linked Server Problem

[TK]

I have a view to a table in a linked server (an Access mdb
file) that works fine in Enterprise Manager and Query
Analyzer, but when the view is executed in the Access adp
I get an error saying:

"Microsoft Access can't find the
object 'dbo.ExternalTable.'" where "ExternalTable" is the
name of the view.

Strangely, the view can be executed by other views or
stored procedures in the project, so I suspect the problem
is related to the inclusion of the "dbo." prefix that
Access adds to the view name. Can anyone confirm this or
provide another explanation?

Meanwhile I do have a workaround since I created another
view that returns the results of the first one, and while
this works OK, I would like to eliminate the excess
clutter.

TIA for any help,

TK

 

[Guest]

I don't have a lot of experience with linked servers, but I think you need to call the view in the ServerName.Datebase.Owner.ViewName format.

Good luck

 

[TK]

Thanks for the reply.

I think the 2nd and 3rd parts of the syntax are
for "table_catalog" and "table_schema" and are not used
for an Access reference. In any case, I have tried adding
values for these without success.

However, I have now come to realize that the object that
the error message claims can't be found is actually the
view that I am trying to execute, not directly related to
the linked server tables!

I am starting to think that there is some corruption in
the access project causing it to lose track of its
objects.

Any other thoughts on what could cause this?

-----Original Message-----
I don't have a lot of experience with linked servers, but

I think you need to call the view in the
ServerName.Datebase.Owner.ViewName format.