Re: relink oracle linked tables in code

I ***suspect*** (guessing here) that Oracle can have tables with the same
name in a database that are distinguished by the owner name. Something akin
to the way Access can have a control named "cboxGetStuff" on multiple forms.
As I recall MS SQL server can have multiple tables with the same name that
must be distinguished by owner name and database name in certain contexts.

Beyond that tid bit, I have no advice to offer since I have not worked with
Oracle.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"raj" <raj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:069D4790-8EB2-4B11-8BF7-53F246CE63A5@xxxxxxxxxxxxxxxx
Hi Stefan,

Thanks for your reply.

I tried your suggestion, but i am getting

"There are several tables with that name. Please specify owner in the
format
'owner.table'. (Error 3298)"

But my oracle db contains only 1 table with that name.

"Stefan Hoffmann" wrote:

hi Raj,

raj wrote:
I need to relink the linked tables during the application startup
depending
up on the users selection of oracle database.

With CurrentDb
TableDefs.Append _
.CreateTableDef(ADestinationName, 0, _
ASourceName, CONNECTION_ODBC)
End With

Where

- ADestinationName is the name of the linked table in Acces
- ASourceName is the qualified (schema.name) of the table or view in
Oracle.
- CONNECTION_ODBC is the connection string (see connectionstrings.com)


mfG
--> stefan <--



.

Relevant Pages

  • Re: Multiple databases - best performance scenario
    ... My company has the need to manage data for multiple customers. ... Multiple small physical servers connected to SAN ... When I'm using the word database ... You might consider checking licensing costs at the oracle store ...
    (comp.databases.oracle.server)
  • Re: Basic Oracle Concepts
    ... A sqlserver database is more or less the ... Multiple Oracle Homes are created during installation. ...
    (comp.databases.oracle.misc)
  • Re: impdp changes owner of jobs
    ... today I imported a full database export of an Oracle 10.2.0.3 database ... See bug 5620345 ... 1.Qualify the function name with owner of the function while ...
    (comp.databases.oracle.server)
  • Re: Access and Linked tables to Oracle
    ... The initial Access database was created in Access 2000. ... database on multiple machines with similar results in all cases. ... We are using the Oracle ODBC drivers for the database connectivity. ... is really slow if the primary key gets created on that table ...
    (microsoft.public.access.tablesdbdesign)
  • Re: copy tables from one oracle server to another one
    ... one oracle database in to another oracle database.Both of these oracle ... syntax (this would require a database link). ... default tablespace of the new 'owner', but I think it would be easier ... on the uninitiated to create, or have created, the same tablespaces on ...
    (comp.databases.oracle.server)
Loading