Linked Server Problem
From: TK (anonymous_at_discussions.microsoft.com)
Date: 07/14/04
- Next message: Roy Goldhammer: "Return Store Prosedure Error"
- Previous message: Dan H: "new project, existing data, opens read only"
- Next in thread: Siamak: "RE: Linked Server Problem"
- Reply: Siamak: "RE: Linked Server Problem"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 14 Jul 2004 11:30:04 -0700
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
- Next message: Roy Goldhammer: "Return Store Prosedure Error"
- Previous message: Dan H: "new project, existing data, opens read only"
- Next in thread: Siamak: "RE: Linked Server Problem"
- Reply: Siamak: "RE: Linked Server Problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
