I have linked my SQL Server 7.0 sp1 database tables to an access database.
When I try to open some of the tables, I get "Couldn't execute query;
couldn't find linked table".
I could understand all or none of the tables working, but the "some of the
tables" is kicking my butt.
Right now the database is wide open, so there is no permissions problem.
I did an ODBC trace, opening a working table and then a non-working table.
The working table generated :
MSACCESS fb:cd EXIT SQLExecDirect with return code 0
UCHAR * 0x0dec0d20 [ -3] "SELECT
"dbo"."OPTION_Frnmod"."Frnmod" FROM "dbo"."OPTION_Frnmod" \ 0"
The non-working table generated:
MSACCESS fb:cd EXIT SQLExecDirect with return code -1 (SQL_ERROR)
UCHAR * 0x113c0d30 [ -3] "SELECT
"dbo"."OPTION_Adsize"."AdSize" FROM "dbo"."OPTION_Adsize" \ 0"
If I user Query Analyzer, both queries return data.
Any Ideas what the heck is going on?
Thanks in advance