Retrieve source-name for linked tables

[oj]

Hi,
our Access2000 application contains links to Oracle-tables
using ODBC.
I wish to implement a functionality for changing source
schema. To do this I need to know the source-tablename for
the linked tables.
I've tried to use the SourceTableName-property for the
TableDefs object, but this property seems to only handle
32 characters !
For example for a link to a table called
DVKS_DB_PREFIX_SUFFIX_GROUP in schema KSDB01A, this
property returns KSDB01A.DVKS_DB_PREFIX_SUFFIX_GR .

Is there a workaround for retrieving the complete name ?
Thanks in advance !

 

[MichaelRed]

Look at the MSysObjects table. It is normally hidden, but is accessable ethier by showing hidden objects or by doing a query on in.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[downwitchyobadself]

Are you using the Connect string to check SourceTableName? The SourceTableName property native to the linked table is only supposed to work on Jet dbs. There's an example under VBA help, SourceTableName topic, of a Connect that sets several types of link, Oracle not being one of them (competition, anyone?), but I would think the principle would be the same?