Cannot see my tables when connecting via ODBC

[AlbertAguirre]

I'm developing a web app and I cannot query on my one and only table in my SQLServer database.

I also tried viewing my tables in MSAccess2000 but same reults. I cannot see my table.

I am new to SQL Server. Please help.

I already checked permissions with my limited knowledge it looks good to me. Tables are available to "public". I created my login name and connect to the database OK.
I gave access to everyone for everything trying to fix this problem. No luck.

I am desperate, please help...

 

[sguslan]

In the ODBC profile, make sure you chose the correct database as default, and when doing and dynamic sql fully qualify the table name like dbname.dbo.tablename...