load all ODBC database string

  • Thread starter Thread starter Raymond Chiu
  • Start date Start date
R

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
 
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
 
Back
Top