T
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
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