Sunday, March 11, 2012

Connection from Access to SQL Server does not show ALL tables

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 ?
--
SteveNo, 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 ca
n
>see some of the tables but not all of them when i try to establish a link t
o
>a table.
>any ideas? Is there such a thing as a hidden table at the SQL server end ?

No comments:

Post a Comment