Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle ODBC Access
Jeff Arledge wrote:
> I have an ACCESS db that I am trying to make links to tables on an
> Oracle DB. Why I choose link and complete the logon onto the Oracle
> DB I only get back one table. According to the DBAs I have full
> access to all tables in the Oracle DB.
>
> Any clues or suggestions?
>
> Thanks,
> Jeff
Log on with the same user-id and password the DBAs gave you but using SQL*Plus and perform the following query:
SELECT COUNT(*)
FROM all_tables;
That will give you the actual count of tables you can see. If it is different from what you see in Access the problem with with ODBC/Access. If it is the same the problem is with the DBAs.
Daniel Morgan Received on Tue Apr 30 2002 - 10:06:43 CDT
![]() |
![]() |