Retrieve password connection string Microsoft access ODBC

Question

I have an old Microsoft Access program for old client in my company and they forget the connection string. I have linked tables to SQL server database using ODBC - can I retrieve username and password? I already tried to get the connection string using the property In the Design view but the username and password are hidden. Please help me. Thanks.

Answer 1

It's only hidden in the UI for linked tables. The actual connect string is readily available in VBA, e.g. in the Immediate window:

Debug.Print CurrentDb.TableDefs("MyLinkedTable").Connect