Re: Oracle ODBC Access

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 30 Apr 2002 15:06:43 GMT
Message-ID: <3CCEB301.B414EDFC@exesolutions.com>

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