Re: relink oracle linked tables in code
- From: "John Spencer" <spencer@xxxxxxxxx>
- Date: Mon, 16 Jul 2007 07:32:01 -0400
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 <--
.
- References:
- Re: relink oracle linked tables in code
- From: Stefan Hoffmann
- Re: relink oracle linked tables in code
- Prev by Date: What is wrong with this code?
- Next by Date: RE: SUM query, variable problem
- Previous by thread: Re: relink oracle linked tables in code
- Next by thread: Re: Creating a 'join two fields' function
- Index(es):
Relevant Pages
|
