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:
(cutting off the file name)
And the SourceTableName is:
(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?
I've been working in VBA for over a year and I STILL feel like a beginner!