load all ODBC database string

[Raymond Chiu]

Dear all,

If I have the database with some ODBC linking strings, How can I retrieve
all these ODBC database connection string on the window?
it can be similar to retriving all access database object name in SQL
statement.

Thanks for your big help,

Raymond

 

[Albert D. Kallal]

You can use the following expression:

currentdb.TableDefs("dbo_tbljunk").Connect

It is not quite clear what you mean by "window", but you can certanly type
the above expression direclity into the debug window.

? currentdb.TableDefs("dbo_tbljunk").Connect