sql server odbc: Connection from Access to SQL Server does not show ALL tables -- sql server odbc

Connection from Access to SQL Server does not show ALL tables

Steve
2/3/2006 9:50:21 AM

sql server odbc:

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

Re: Connection from Access to SQL Server does not show ALL tables

Mary Chipman [MSFT]
2/3/2006 5:29:47 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"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.