Case of the disappearing table

I have Access linked to a SQL Database. There is one table that shows up using Microsoft SQL Server Management Studio that Access cannot see. I have unhidden all files in the options. Why can't I see this table? It does not appear any different than the others using Studio.

re: Case of the disappearing table

Maybe something is wrong with its name? Some specific characters in it?

If its everything ok, try querying it from Access - maybe you will get some diagnostic messages.

As last resort you can recreate the table and put data back in it.

re: Case of the disappearing table

Thanks for your reply Max. I found the solution. The database was originally linked late in 2008. This table was added in Feb 2009. I had to go back and relink this table.
1. External Data / Import / More
2. Link to the Data Source
3. Machine Data Source

After the user/password I could see the tables and brought it into Access. I thought the Linked Table Manager should take care of this.