MS SQL Server ODBC - Connection from Access to SQL Server does not show ALL tables

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Connection from Access to SQL Server does not show ALL tables

Steve

2006-02-03, 1:23 pm

I have an ODBC connection to a SQL server database and for some reason I can
see some of the tables but not all of them when i try to establish a link to
a table.

any ideas? Is there such a thing as a hidden table at the SQL server end ?
--
Steve

Mary Chipman [MSFT]

2006-02-03, 8:23 pm

No, there is not. I'd check your permissions to see if you have
adequate permissions for the ODBC login/DSN you are using to connect,
and if that's not it, check the syntax in your code for typos in
names, etc.

--Mary

On Fri, 3 Feb 2006 09:50:21 -0800, "Steve"
<Steve@discussions.microsoft.com> wrote:

>I have an ODBC connection to a SQL server database and for some reason I can
>see some of the tables but not all of them when i try to establish a link to
>a table.
>
>any ideas? Is there such a thing as a hidden table at the SQL server end ?

Sponsored Links