Why do I only see SYS and INFORMATION_SCHEMA tables? Access 2007 ODB to SQL Server 2008
Thanks to Jimbo and Shark's comments I was able to fix my problem by adjusting the permission for the tables I wanted to see. I did not have SELECT permission on the tables so I was not able to see them. Once I added the SELECT permission to the tables I was then able to see my data perfectly.