Retrieving the SQL Server Name of a ODBC Linked Table in Access 20

[Guest]

Hello everyone:

I have tried to do research regarding this question in this forum but
apologize if it has been submitted and/or answered in the past. Here is my
question:

My collegue has an Access 2000 database which contains 3 linked (via ODBC I
imagine) tables to a SQL 2000 backend. His question was: Is there anyway
via code or in the Access 2000 application for him to retrieve what SQL
Server those linked tables are located on? He had mentioned about needing to
know if those tables were linked to the production SQL Server or development
SQL Server. I hope this question made sense.

Thank you in advance for any assistance.

Amar

 

[Rick Brandt]

Hello everyone:

I have tried to do research regarding this question in this forum but
apologize if it has been submitted and/or answered in the past. Here is my
question:

My collegue has an Access 2000 database which contains 3 linked (via ODBC I
imagine) tables to a SQL 2000 backend. His question was: Is there anyway
via code or in the Access 2000 application for him to retrieve what SQL
Server those linked tables are located on? He had mentioned about needing to
know if those tables were linked to the production SQL Server or development
SQL Server. I hope this question made sense.

Thank you in advance for any assistance.

Look at...

CurrentDB.TableDefs("TableName").Connect

 

[Guest]

Rick:

Thank you. this is perfect!!! just want I needed.