I have numerous tables in a file that are links to tables external to the file. I'm trying to list the source data files and tables using VBA, for documentation.

All I have read says that this information is found in tabledefs, but apparently there's a field size limitation that cuts off connect and source tablename strings.

For instance, I have an ODBC table in Oracle that's linked to table APPS.GEC_ACCT_ID_FND_FLEX_VALUE_FIRST_QUARTER

But the Connect string in tabledefs looks like:
ODBC;DSN=ORACLE GL;DBQ=GLPROD;DBA=W;APA=T;FEN=T;QTO=F;FRC=10;FDL=10;LOB=T;RST=T;FRL=F;MTS=F;CSR=
F;PFC=10;TLO=0;DATABASE=
(cutting off the file name)

And the SourceTableName is:
APPS.GEC_ACCT_ID_FND_FLEX_VALUE_
(not the whole file name).

I can see the entire connection string if I manually design the table and look at "Description" in properties, but I need to have VBA get the info.

Is this information available anywhere else that VBA can see?

Thanks

Dave Gulliksen
Stratford, CT

I've been working in VBA for over a year and I STILL feel like a beginner!

I think I've found it, in the MSysObjects table. The Connect string is still cut off, but the file names in the "Foreign Name" column and the path in the "Database" column look complete.

Dave Gulliksen
Stratford, CT