Cant See Tables in SQL Server 2000

This is a re-post as I didn't get a resolution to the problem
Using MDAC 2.8
I have set up my SQL Server and set SQL SERVER authentication and for some
reason when I connect through ODBC I can't see any of the tables. It logs
into SQL server just fine, I have set the appropriate rights to the tables
etc. If I log on as system admin I can see the tables but can't update any
of the data.
Any ideas?What utility/tool/program are you using? Are you sure you're being connecte
d
to the database that you're expecting?

> Using MDAC 2.8
> I have set up my SQL Server and set SQL SERVER authentication and for some
> reason when I connect through ODBC I can't see any of the tables. It logs
> into SQL server just fine, I have set the appropriate rights to the tables
> etc. If I log on as system admin I can see the tables but can't update an
y
> of the data.
> Any ideas?
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq|||Hey Neil,
Thanks for the reply..
I am suing Access 97/2000/2003 to link to the tables. Again it connects
fine, but the tables are not displayed.
Thanks!
Barry
"Neil Pike" <neilpike@.compuserve.com> wrote in message
news:VA.000061cf.021cee1a@.compuserve.com...
> What utility/tool/program are you using? Are you sure you're being
connected
> to the database that you're expecting?
>
some
logs
tables
any
> Neil Pike MVP/MCSE. Protech Computing Ltd
> Reply here - no email
> SQL FAQ (484 entries) see
> http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
> (faqxxx.zip in lib 7)
> or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> or www.sqlserverfaq.com
> or www.mssqlserver.com/faq
>|||Barry - connect using query analyser (ISQLW) and see if you can see the
tables.

> I am suing Access 97/2000/2003 to link to the tables. Again it connects
> fine, but the tables are not displayed.
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq