Hi I experience something weird

[fatchoy]

Hi
I experience something weird here. I try to access an Oracle table through Ms-Query. Though I can read it through Ms-Access and ODBC test, with both Oracle and Microsoft for Oracle drivers, when I try
with Ms-Query, I get an "ORA-00903 Invalid table name"

I also discovered that only some tables have this problem,
not all the tables.

Pls Advise if you come across this problem.
thanks

 

[keden]

I have not used MS Query but I know that with applications I have used, the host of the dB you are accessing can grant privelages to certain tables. I ran into a similar problem with a recent server conversion. My access was restricted to accessing certain tables. I had to have my access restored to where it was prior to the conversion.

This may be basic and not sure if this helps but thought I would share.