A
Allen_N
I want to be able to query a table in another database from an Access 2003
Project.
If try to import the table OK, Access after the progress bar reaches
maximum. (I don't really want to import, anyway, because this runs the risk
of forgetting to redo the import when the table is no longer current.)
If I try to refer to the table in the view SQL, like this:
SELECT * FROM company.dbo.Stock
.... I get the message "Unspecified Error". (Very helpful, that one.)
If I try to build a 'Transact SQL' link to the table, I get to choose the
data source ("company Stock.odc"), and I get as far as choosing the table
name from a scrollable list. Then I get an error message: "Invalid object
name 'NS'." I don't know where this 'NS' thing is coming from.
I have successfully linked to this table from an Access Database, but I
can't do this for my current application.
In Enterprise Manager, the 'company' database does not appear in the list.
Can anyone suggest what I am up against?
Project.
If try to import the table OK, Access after the progress bar reaches
maximum. (I don't really want to import, anyway, because this runs the risk
of forgetting to redo the import when the table is no longer current.)
If I try to refer to the table in the view SQL, like this:
SELECT * FROM company.dbo.Stock
.... I get the message "Unspecified Error". (Very helpful, that one.)
If I try to build a 'Transact SQL' link to the table, I get to choose the
data source ("company Stock.odc"), and I get as far as choosing the table
name from a scrollable list. Then I get an error message: "Invalid object
name 'NS'." I don't know where this 'NS' thing is coming from.
I have successfully linked to this table from an Access Database, but I
can't do this for my current application.
In Enterprise Manager, the 'company' database does not appear in the list.
Can anyone suggest what I am up against?