Re: How can user name/table name concatenation be prevented when using ODBC?

I don't have an answer other than renaming the tables manually in Access after attaching them.

However, I have a related question. Is there a limit to the number of tables that will be shown when using ODBC in Access?

When I try to attach from Access to my DBA account in Oracle, I fail to get the last tables. For example, if a table is called RGR.SSTABLE, it won't show, but RGR.AATABLE will. 'RGR' is my user id and since this is a DBA account, I have access to all tables in the database.

Richard

ronald_at_mix004.nwg.dec.com (Ronald van der Burg) wrote:
>In article <NEWTNews.818179657.26699.bruce_at_ga.bst.bls.com>,
>bruce.douglas_at_bridge.bst.bls.com says...
>>
>>
>>In Article<49mfp0$a55_at_mrnews.mro.dec.com>, <ronald_at_mix004.nwg.dec.com>
 writes:
>>
>>>
>>> Oracle concatenates user names and table names, for example user "diane"
 and  

>>> table "product_table" becomes "diane.product_table". When the database is
>>> accessed via ODBC, I would like to access tables using table names (or
 public synonyms) only.
>>>
>>> I tried public synonyms. This works if a user logs in into Oracle directly.
>>> But if access is done via ODBC, these synonyms don't show up in a normal
>>way. They are only visible if system names are requested also. But system
>>names are not visible if you try to use attached tables with MS-Access 2.0.
>>
>>
>
Received on Wed Dec 06 1995 - 00:00:00 CET